APPS.ENGPKIMP dependencies on BOM_STRUCTURES_B

Line 2809: FROM bom_structures_b

2805:
2806: Cursor get_bill_effectivity_control (cp_bill_id NUMBER)
2807: Is
2808: SELECT effectivity_control
2809: FROM bom_structures_b
2810: WHERE bill_sequence_id = cp_bill_id;
2811:
2812: Cursor check_impl_revision ( cp_revision_id NUMBER
2813: , cp_item_id NUMBER

Line 2895: FROM bom_structures_b bsb

2891:
2892: -- R12 : Changes for common BOM
2893: CURSOR check_if_commoned_bom( cp_bill_id IN NUMBER) IS
2894: SELECT nvl(bsb.SOURCE_BILL_SEQUENCE_ID, bsb.BILL_SEQUENCE_ID) SOURCE_BILL_SEQUENCE_ID
2895: FROM bom_structures_b bsb
2896: WHERE bsb.source_bill_sequence_id = cp_bill_id
2897: AND bsb.bill_sequence_id <> bsb.source_bill_sequence_id;
2898: -- Cursor to fetch the valid value of effectivity date when the
2899: -- effectivity date is in the future.

Line 2908: FROM bom_structures_b bsb

2904: WHERE bcb.revised_item_sequence_id = cp_rev_seq_id
2905: AND bcb.bill_sequence_id = cp_bill_id
2906: AND EXISTS
2907: (SELECT 1
2908: FROM bom_structures_b bsb
2909: WHERE bsb.bill_sequence_id = cp_bill_id
2910: AND bsb.bill_sequence_id <> bsb.source_bill_sequence_id)
2911: AND ROWNUM < 2;
2912:

Line 8662: FROM bom_components_b rbcb, bom_structures_b bsb

8658: DELETE FROM bom_components_b
8659: WHERE implementation_date IS NULL -- as pending changes were copied to the new component
8660: AND (bill_sequence_id, old_component_sequence_id) IN
8661: (SELECT bsb.bill_sequence_id, rbcb.component_sequence_id
8662: FROM bom_components_b rbcb, bom_structures_b bsb
8663: WHERE bsb.bill_sequence_id <> p_bill_sequence_id
8664: AND bsb.source_bill_sequence_id = p_bill_sequence_id
8665: AND rbcb.bill_sequence_id = bsb.bill_sequence_id
8666: AND rbcb.revised_item_sequence_id = p_revised_item_sequence_id);