DBA Data[Home] [Help]

APPS.BOM_STRUCT_SYNC_PUB dependencies on XMLAGG

Line 232: XMLAgg(XMLElement(

228: /*Bug 6407303 Added the attribute OPERATING_UNIT_ID */
229: SELECT
230: XMLElement("db:listOfBillOfMaterial",
231: XMLATTRIBUTES ( 'http://xmlns.oracle.com/pcbpel/adapter/db/APPS/BOM_STRUCT_SYNC_PUB/GET_STRUCTURE_PAYLOAD/' AS "xmlns:db"),
232: XMLAgg(XMLElement(
233: "db:billOfMaterial",
234: XMLAttributes(comp_bill_seq_id as "BillSequenceId"),
235: XMLForest(component_item_name as "db:AssemblyName"),
236: XMLForest(nvl(component_item_id, assembly_item_id) as "db:AssemblyItemId"),

Line 242: XMLAgg(XMLElement(

238: XMLForest(ORGANIZATION_CODE as "db:OrganizationCode"),
239: XMLForest(ORGANIZATION_ID as "db:OrganizationId"),
240: XMLForest(OPERATING_UNIT_ID as "db:OperatingUnitId"),
241: (SELECT XMLElement("db:listOfBomComponent",
242: XMLAgg(XMLElement(
243: "db:billOfMaterialComponent",
244: XMLAttributes(
245: component_item_id as "Id"),
246: XMLForest(