APPS.ENI_DBI_PCO_LOAD_PKG dependencies on BOM_IMPLOSION_TEMP

Line 131: --Remove duplicates from BOM_IMPLOSION_TEMP

127: impl_date => TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI'),
128: err_msg => o_error_msg,
129: err_code => o_error_code);
130:
131: --Remove duplicates from BOM_IMPLOSION_TEMP
132: --as ENI_DBI_PCO_WORKER_ASSIGNMENTS already has rows
133: DELETE FROM bom_implosion_temp bit
134: WHERE EXISTS (SELECT NULL
135: FROM eni_dbi_pco_worker_assignments p

Line 133: DELETE FROM bom_implosion_temp bit

129: err_code => o_error_code);
130:
131: --Remove duplicates from BOM_IMPLOSION_TEMP
132: --as ENI_DBI_PCO_WORKER_ASSIGNMENTS already has rows
133: DELETE FROM bom_implosion_temp bit
134: WHERE EXISTS (SELECT NULL
135: FROM eni_dbi_pco_worker_assignments p
136: WHERE p.assembly_item_id = bit.parent_item_id
137: and p.organization_id = bit.organization_id);

Line 161: BOM_IMPLOSION_TEMP bit, BOM_BILL_OF_MATERIALS bbom

157: msi.organization_id = bit.organization_id) AS bom_item_type,
158: NULL as worker_id,
159: 0 as incr_status
160: FROM
161: BOM_IMPLOSION_TEMP bit, BOM_BILL_OF_MATERIALS bbom
162: WHERE
163: bit.parent_item_id = bbom.assembly_item_id
164: AND bit.organization_id = bbom.organization_id
165: AND bbom.bill_sequence_id = bbom.common_bill_sequence_id

Line 168: DELETE FROM bom_implosion_temp;

164: AND bit.organization_id = bbom.organization_id
165: AND bbom.bill_sequence_id = bbom.common_bill_sequence_id
166: AND bbom.alternate_bom_designator IS NULL);
167:
168: DELETE FROM bom_implosion_temp;
169: END LOOP; -- Completed Implosion all the Modified Bills.
170: COMMIT;
171: dbms_mview.refresh('ENI_DBI_BOM_COMPONENTS_MV2','F');
172: