DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on BOM_BILL_OF_MATERIALS

Line 2115: bom_bill_of_materials bbm,

2111: from
2112: oe_order_lines_all oel,
2113: bom_explosion_temp bet,
2114: mtl_system_items msi,
2115: bom_bill_of_materials bbm,
2116: bom_inventory_components bic
2117: where oel.ato_line_id = pLineId
2118: and oel.line_id <> pLineId
2119: and oel.inventory_item_id = msi.inventory_item_id

Line 2276: bom_bill_of_materials bom,

2272: mtl_system_items msi, /* PARENT */
2273: mtl_system_items msi2, /* CHILD */
2274: bom_inventory_components bic,
2275: eng_revised_items eri,
2276: bom_bill_of_materials bom,
2277: mtl_parameters mp,
2278: bom_explosion_temp be
2279: where be.sort_order <> 3 -- 1288823
2280: and be.group_id = xGrpId

Line 2683: bom_bill_of_materials bom,

2679: mtl_system_items msi,
2680: mtl_system_items msi2,
2681: bom_inventory_components bic,
2682: eng_revised_items eri,
2683: bom_bill_of_materials bom,
2684: mtl_parameters mp,
2685: bom_explosion_temp be
2686: where be.sort_order <> 3
2687: and be.group_id = xGrpId

Line 3064: bom_bill_of_materials bom,

3060: bet.top_item_id,
3061: 1,
3062: xGrpId
3063: from
3064: bom_bill_of_materials bom,
3065: bom_inventory_components bic,
3066: mtl_system_items msi, -- bugfix 1998386
3067: bom_explosion_temp bet,
3068: bom_explosion_temp bet2 /* ship set */

Line 3216: bom_bill_of_materials bom,

3212: mtl_system_items msi, /* PARENT */
3213: mtl_system_items msi2, /* CHILD [BUG#1518894] */
3214: bom_inventory_components bic,
3215: eng_revised_items eri,
3216: bom_bill_of_materials bom,
3217: mtl_parameters mp,
3218: bom_explosion_temp be
3219: where be.sort_order <> 3
3220: and be.group_id = xGrpId

Line 3515: bom_bill_of_materials bom,

3511: bet.top_item_id,
3512: 1,
3513: xGrpId
3514: from
3515: bom_bill_of_materials bom,
3516: bom_inventory_components bic,
3517: mtl_system_items msi,
3518: bom_explosion_temp bet,
3519: bom_explosion_temp bet2

Line 3630: bom_bill_of_materials bom,

3626: mtl_system_items msi,
3627: mtl_system_items msi2,
3628: bom_inventory_components bic,
3629: eng_revised_items eri,
3630: bom_bill_of_materials bom,
3631: mtl_parameters mp,
3632: bom_explosion_temp be
3633: where be.sort_order <> 3
3634: and be.group_id = xGrpId