APPS.BOMPKMUD dependencies on BOM_STRUCTURES_B

Line 372: FROM bom_structures_b b,

368: AND cii.acd_type IN (action_add))
369: For bug 8550652 */
370: AND NOT EXISTS (
371: SELECT NULL
372: FROM bom_structures_b b,
373: bom_components_b c
374: WHERE
375: b.assembly_item_id = l.assembly_item_id
376: AND b.organization_id = p_org_id

Line 930: FROM bom_structures_b b,

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

Line 1023: FROM bom_structures_b b

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

Line 1040: bom_structures_b b,

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