APPS.ENGPKIMP dependencies on BOM_STRUCTURES_B

Line 2940: FROM bom_structures_b

2936:
2937: Cursor get_bill_effectivity_control (cp_bill_id NUMBER)
2938: Is
2939: SELECT effectivity_control
2940: FROM bom_structures_b
2941: WHERE bill_sequence_id = cp_bill_id;
2942:
2943: Cursor check_impl_revision ( cp_revision_id NUMBER
2944: , cp_item_id NUMBER

Line 3026: FROM bom_structures_b bsb

3022:
3023: -- R12 : Changes for common BOM
3024: CURSOR check_if_commoned_bom( cp_bill_id IN NUMBER) IS
3025: SELECT nvl(bsb.SOURCE_BILL_SEQUENCE_ID, bsb.BILL_SEQUENCE_ID) SOURCE_BILL_SEQUENCE_ID
3026: FROM bom_structures_b bsb
3027: WHERE bsb.source_bill_sequence_id = cp_bill_id
3028: AND bsb.bill_sequence_id <> bsb.source_bill_sequence_id;
3029: -- Cursor to fetch the valid value of effectivity date when the
3030: -- effectivity date is in the future.

Line 3039: FROM bom_structures_b bsb

3035: WHERE bcb.revised_item_sequence_id = cp_rev_seq_id
3036: AND bcb.bill_sequence_id = cp_bill_id
3037: AND EXISTS
3038: (SELECT 1
3039: FROM bom_structures_b bsb
3040: WHERE bsb.bill_sequence_id = cp_bill_id
3041: AND bsb.bill_sequence_id <> bsb.source_bill_sequence_id)
3042: AND ROWNUM < 2;
3043:

Line 9007: FROM bom_components_b rbcb, bom_structures_b bsb

9003: DELETE FROM bom_components_b
9004: WHERE implementation_date IS NULL -- as pending changes were copied to the new component
9005: AND (bill_sequence_id, old_component_sequence_id) IN
9006: (SELECT bsb.bill_sequence_id, rbcb.component_sequence_id
9007: FROM bom_components_b rbcb, bom_structures_b bsb
9008: WHERE bsb.bill_sequence_id <> p_bill_sequence_id
9009: AND bsb.source_bill_sequence_id = p_bill_sequence_id
9010: AND rbcb.bill_sequence_id = bsb.bill_sequence_id
9011: AND rbcb.revised_item_sequence_id = p_revised_item_sequence_id);