Getting Invalid number of parameters. Expected: 6. Provided: 0. - Would someone be able to assist pls?

SELECT 
  BUILTIN_RESULT.TYPE_INTEGER(bomRevision.billofmaterials) AS billofmaterials, 
  BUILTIN_RESULT.TYPE_FLOAT(bomRevisionComponentMember_SUB.quantity) AS formula_10, 
  BUILTIN_RESULT.TYPE_STRING(BUILTIN.DF(bom_SUB.bomrevision)) AS formula_7, 
  BUILTIN_RESULT.TYPE_BOOLEAN(bom_SUB.isinactive) AS formula_6, 
  BUILTIN_RESULT.TYPE_STRING(BUILTIN.DF(bom_SUB.assembly)) AS formula_0, 
  BUILTIN_RESULT.TYPE_STRING(BUILTIN.DF(bomRevisionComponentMember_SUB.item)) AS formula_5, 
  BUILTIN_RESULT.TYPE_STRING(bomRevisionComponentMember_SUB.description) AS formula_8, 
  BUILTIN_RESULT.TYPE_DATE(bomRevision.effectiveenddate) AS formula_2, 
  BUILTIN_RESULT.TYPE_DATE(bomRevision.effectivestartdate) AS formula_3
FROM 
  bomRevision, 
  (SELECT 
    bom.ID AS ID, 
    bom.ID AS id_join, 
    bom.bomrevision AS bomrevision, 
    bom.isinactive AS isinactive, 
    bomAssemblyLocation.assembly AS assembly, 
    bom.isinactive AS isinactive_crit, 
    bom.legacybomforassembly AS legacybomforassembly_crit, 
    bomAssemblyLocation.ismasterdefaultbom AS ismasterdefaultbom_crit
  FROM 
    bom, 
    bomAssemblyLocation
  WHERE 
    bom.ID = bomAssemblyLocation.billofmaterials(+)
  ) bom_SUB, 
  (SELECT 
    bomRevisionComponentMember.bomrevision AS bomrevision, 
    bomRevisionComponentMember.bomrevision AS bomrevision_join, 
    bomRevisionComponentMember.quantity AS quantity, 
    bomRevisionComponentMember.item AS item, 
    bomRevisionComponentMember.description AS description, 
    item.itemid AS itemid_crit
  FROM 
    bomRevisionComponentMember, 
    item
  WHERE 
    bomRevisionComponentMember.item = item.ID(+)
  ) bomRevisionComponentMember_SUB
WHERE 
  ((bomRevision.billofmaterials = bom_SUB.ID(+) AND bomRevision.ID = bomRevisionComponentMember_SUB.bomrevision(+)))
   AND (((UPPER(bomRevisionComponentMember_SUB.itemid_crit) NOT LIKE ? OR bomRevisionComponentMember_SUB.itemid_crit IS NULL) AND NVL(bom_SUB.isinactive_crit, 'F') = ? AND bom_SUB.legacybomforassembly_crit IS NULL AND NVL(bom_SUB.isinactive_crit, 'F') = ? AND (UPPER(bomRevisionComponentMember_SUB.itemid_crit) NOT LIKE ? OR bomRevisionComponentMember_SUB.itemid_crit IS NULL) AND NVL(bomRevision.isinactive, 'F') = ? AND bom_SUB.ismasterdefaultbom_crit = ? AND bomRevision.effectiveenddate IS NULL))

need to provide parameters for all the question mark placeholders in your query. Have a read of Oracle Docs - SuiteQL.params