DBA Data[Home] [Help]

APPS.FLM_KANBAN_PURGE dependencies on BOM_INVENTORY_COMPONENTS

Line 143: FROM BOM_INVENTORY_COMPONENTS BIC,

139: INTO l_records_found
140: FROM DUAL
141: WHERE EXISTS (
142: SELECT 1
143: FROM BOM_INVENTORY_COMPONENTS BIC,
144: BOM_BILL_OF_MATERIALS BBM
145: WHERE BIC.bill_sequence_id = BBM.bill_sequence_id
146: AND BBM.organization_id = arg_org_id
147: AND BIC.component_item_id = arg_item_id

Line 163: FROM BOM_INVENTORY_COMPONENTS BIC,

159: INTO l_records_found
160: FROM DUAL
161: WHERE EXISTS (
162: SELECT 1
163: FROM BOM_INVENTORY_COMPONENTS BIC,
164: BOM_BILL_OF_MATERIALS BBM
165: WHERE BIC.bill_sequence_id = BBM.bill_sequence_id
166: AND BBM.organization_id = arg_org_id
167: AND BIC.component_item_id = arg_item_id