DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on BOM_BILL_OF_MATERIALS

Line 2022: bom_bill_of_materials bbm,

2018: from
2019: oe_order_lines_all oel,
2020: bom_explosion_temp bet,
2021: mtl_system_items msi,
2022: bom_bill_of_materials bbm,
2023: bom_inventory_components bic
2024: where oel.ato_line_id = pLineId
2025: and oel.line_id <> pLineId
2026: and oel.inventory_item_id = msi.inventory_item_id

Line 2183: bom_bill_of_materials bom,

2179: mtl_system_items msi, /* PARENT */
2180: mtl_system_items msi2, /* CHILD */
2181: bom_inventory_components bic,
2182: eng_revised_items eri,
2183: bom_bill_of_materials bom,
2184: mtl_parameters mp,
2185: bom_explosion_temp be
2186: where be.sort_order <> 3 -- 1288823
2187: and be.group_id = xGrpId

Line 2590: bom_bill_of_materials bom,

2586: mtl_system_items msi,
2587: mtl_system_items msi2,
2588: bom_inventory_components bic,
2589: eng_revised_items eri,
2590: bom_bill_of_materials bom,
2591: mtl_parameters mp,
2592: bom_explosion_temp be
2593: where be.sort_order <> 3
2594: and be.group_id = xGrpId

Line 2971: bom_bill_of_materials bom,

2967: bet.top_item_id,
2968: 1,
2969: xGrpId
2970: from
2971: bom_bill_of_materials bom,
2972: bom_inventory_components bic,
2973: mtl_system_items msi, -- bugfix 1998386
2974: bom_explosion_temp bet,
2975: bom_explosion_temp bet2 /* ship set */

Line 3123: bom_bill_of_materials bom,

3119: mtl_system_items msi, /* PARENT */
3120: mtl_system_items msi2, /* CHILD [BUG#1518894] */
3121: bom_inventory_components bic,
3122: eng_revised_items eri,
3123: bom_bill_of_materials bom,
3124: mtl_parameters mp,
3125: bom_explosion_temp be
3126: where be.sort_order <> 3
3127: and be.group_id = xGrpId

Line 3422: bom_bill_of_materials bom,

3418: bet.top_item_id,
3419: 1,
3420: xGrpId
3421: from
3422: bom_bill_of_materials bom,
3423: bom_inventory_components bic,
3424: mtl_system_items msi,
3425: bom_explosion_temp bet,
3426: bom_explosion_temp bet2

Line 3537: bom_bill_of_materials bom,

3533: mtl_system_items msi,
3534: mtl_system_items msi2,
3535: bom_inventory_components bic,
3536: eng_revised_items eri,
3537: bom_bill_of_materials bom,
3538: mtl_parameters mp,
3539: bom_explosion_temp be
3540: where be.sort_order <> 3
3541: and be.group_id = xGrpId