eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_ITEM_PK dependencies on BOM_INVENTORY_COMPONENTS

Line 2116: bom_inventory_components bic

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
2120: and oel.ship_from_org_id = msi.organization_id

Line 2274: bom_inventory_components bic,

2270: from
2271: bom_calendar_dates cal,
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

Line 2319: from bom_inventory_components bic1,

2315:
2316: and bic.effectivity_date =
2317: (select
2318: max(effectivity_date)
2319: from bom_inventory_components bic1,
2320: eng_revised_items eri
2321: where bic1.bill_sequence_id = bic.bill_sequence_id
2322: and bic1.component_item_id = bic.component_item_id
2323: and bic1.revised_item_sequence_id =

Line 2342: from bom_inventory_components bicn, eng_revised_items eri1

2338: and ( nvl(eri.status_type,6) IN (4,6,7))
2339: and not exists
2340: (select
2341: 'X'
2342: from bom_inventory_components bicn, eng_revised_items eri1
2343: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
2344: and bicn.old_component_sequence_id =
2345: bic.component_sequence_id
2346: and bicn.acd_type in (2,3)

Line 2681: bom_inventory_components bic,

2677: from
2678: bom_calendar_dates cal,
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

Line 2723: from bom_inventory_components bic1,

2719: and nvl(TRUNC(bic.disable_date),(nvl(cal.calendar_date,sysdate) + 1)) > nvl(cal.calendar_date,sysdate)
2720: and bic.effectivity_date =
2721: (select
2722: max(effectivity_date)
2723: from bom_inventory_components bic1,
2724: eng_revised_items eri
2725: where bic1.bill_sequence_id = bic.bill_sequence_id
2726: and bic1.component_item_id = bic.component_item_id
2727: and bic1.revised_item_sequence_id =

Line 2743: from bom_inventory_components bicn, eng_revised_items eri1

2739: and ( nvl(eri.status_type,6) IN (4,6,7))
2740: and not exists
2741: (select
2742: 'X'
2743: from bom_inventory_components bicn, eng_revised_items eri1
2744: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
2745: and bicn.old_component_sequence_id =
2746: bic.component_sequence_id
2747: and bicn.acd_type in (2,3)

Line 3065: bom_inventory_components bic,

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 */
3069: where bet.group_id = xGrpId

Line 3214: bom_inventory_components bic,

3210: from
3211: bom_calendar_dates cal,
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

Line 3258: from bom_inventory_components bic1,

3254:
3255: and bic.effectivity_date =
3256: (select
3257: max(effectivity_date)
3258: from bom_inventory_components bic1,
3259: eng_revised_items eri
3260: where bic1.bill_sequence_id = bic.bill_sequence_id
3261: and bic1.component_item_id = bic.component_item_id
3262: and bic1.revised_item_sequence_id =

Line 3280: from bom_inventory_components bicn, eng_revised_items eri1

3276: and ( nvl(eri.status_type,6) IN (4,6,7))
3277: and not exists
3278: (select
3279: 'X'
3280: from bom_inventory_components bicn, eng_revised_items eri1
3281: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
3282: and bicn.old_component_sequence_id =
3283: bic.component_sequence_id
3284: and bicn.acd_type in (2,3)

Line 3516: bom_inventory_components bic,

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
3520: where bet.group_id = xGrpId

Line 3628: bom_inventory_components bic,

3624: from
3625: bom_calendar_dates cal,
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

Line 3670: from bom_inventory_components bic1,

3666: and nvl(TRUNC(bic.disable_date),(nvl(cal.calendar_date,sysdate) + 1)) > nvl(cal.calendar_date,sysdate)
3667: and bic.effectivity_date =
3668: (select
3669: max(effectivity_date)
3670: from bom_inventory_components bic1,
3671: eng_revised_items eri
3672: where bic1.bill_sequence_id = bic.bill_sequence_id
3673: and bic1.component_item_id = bic.component_item_id
3674: and bic1.revised_item_sequence_id =

Line 3690: from bom_inventory_components bicn, eng_revised_items eri1

3686: and ( nvl(eri.status_type,6) IN (4,6,7))
3687: and not exists
3688: (select
3689: 'X'
3690: from bom_inventory_components bicn, eng_revised_items eri1
3691: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
3692: and bicn.old_component_sequence_id =
3693: bic.component_sequence_id
3694: and bicn.acd_type in (2,3)