APPS.BOMPKMUD dependencies on BOM_STRUCTURES_B

Line 371: FROM bom_structures_b b,

367: ri.revised_item_sequence_id
368: AND cii.acd_type IN (action_add))
369: AND NOT EXISTS (
370: SELECT NULL
371: FROM bom_structures_b b,
372: bom_components_b c
373: WHERE
374: b.assembly_item_id = l.assembly_item_id
375: AND b.organization_id = p_org_id

Line 929: FROM bom_structures_b b,

925: DELETE FROM bom_lists l
926: WHERE l.sequence_id = p_list_id
927: AND EXISTS (
928: SELECT /*+ ORDERED USE_NL (B C CI CIR RI CO RI_ITM) */ NULL
929: FROM bom_structures_b b,
930: bom_components_b c,
931: bom_inventory_comps_interface ci,
932: bom_inventory_comps_interface cir,
933: eng_revised_items_interface ri,

Line 1022: FROM bom_structures_b b

1018: )
1019: AND EXISTS
1020: (
1021: SELECT NULL
1022: FROM bom_structures_b b
1023: WHERE
1024: b.assembly_type = mfg
1025: AND b.assembly_item_id = l.assembly_item_id
1026: AND b.organization_id = p_organization

Line 1039: bom_structures_b b,

1035: WHERE l.sequence_id = p_list_id
1036: AND EXISTS (
1037: SELECT NULL
1038: FROM bom_components_b c,
1039: bom_structures_b b,
1040: bom_inventory_comps_interface ci,
1041: eng_revised_items_interface ri,
1042: mtl_system_items_b ri_itm
1043: WHERE c.operation_seq_num =