APPS.BOM_STRUCT_SYNC_PUB dependencies on BOM_STRUCTURE_SYNC_V

Line 255: FROM bom_structure_sync_v c

251: DISABLE_DATE as "db:DisableDate",
252: ORGANIZATION_CODE as "db:OrganizationCode",
253: ORGANIZATION_ID as "db:OrganizationId",
254: OPERATING_UNIT_ID as "db:OperatingUnitId"))))
255: FROM bom_structure_sync_v c
256: WHERE c.top_bill_sequence_id=a.top_bill_sequence_id
257: and c.bill_sequence_id= a.comp_bill_seq_id
258: and c.top_item_id <> c.component_item_id and c.effectivity_date <= sysdate --bug#5891992
259: )))) into p_bom

Line 260: FROM bom_structure_sync_v a

256: WHERE c.top_bill_sequence_id=a.top_bill_sequence_id
257: and c.bill_sequence_id= a.comp_bill_seq_id
258: and c.top_item_id <> c.component_item_id and c.effectivity_date <= sysdate --bug#5891992
259: )))) into p_bom
260: FROM bom_structure_sync_v a
261: where a.top_item_id = p_item_id
262: and a.organization_id = p_org_id
263: and a.comp_bill_seq_id is not null
264: order by bill_sequence_id;