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 2023: bom_inventory_components bic

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

Line 2181: bom_inventory_components bic,

2177: from
2178: bom_calendar_dates cal,
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

Line 2226: from bom_inventory_components bic1,

2222:
2223: and bic.effectivity_date =
2224: (select
2225: max(effectivity_date)
2226: from bom_inventory_components bic1,
2227: eng_revised_items eri
2228: where bic1.bill_sequence_id = bic.bill_sequence_id
2229: and bic1.component_item_id = bic.component_item_id
2230: and bic1.revised_item_sequence_id =

Line 2249: from bom_inventory_components bicn, eng_revised_items eri1

2245: and ( nvl(eri.status_type,6) IN (4,6,7))
2246: and not exists
2247: (select
2248: 'X'
2249: from bom_inventory_components bicn, eng_revised_items eri1
2250: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
2251: and bicn.old_component_sequence_id =
2252: bic.component_sequence_id
2253: and bicn.acd_type in (2,3)

Line 2588: bom_inventory_components bic,

2584: from
2585: bom_calendar_dates cal,
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

Line 2630: from bom_inventory_components bic1,

2626: and nvl(TRUNC(bic.disable_date),(nvl(cal.calendar_date,sysdate) + 1)) > nvl(cal.calendar_date,sysdate)
2627: and bic.effectivity_date =
2628: (select
2629: max(effectivity_date)
2630: from bom_inventory_components bic1,
2631: eng_revised_items eri
2632: where bic1.bill_sequence_id = bic.bill_sequence_id
2633: and bic1.component_item_id = bic.component_item_id
2634: and bic1.revised_item_sequence_id =

Line 2650: from bom_inventory_components bicn, eng_revised_items eri1

2646: and ( nvl(eri.status_type,6) IN (4,6,7))
2647: and not exists
2648: (select
2649: 'X'
2650: from bom_inventory_components bicn, eng_revised_items eri1
2651: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
2652: and bicn.old_component_sequence_id =
2653: bic.component_sequence_id
2654: and bicn.acd_type in (2,3)

Line 2972: bom_inventory_components bic,

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

Line 3121: bom_inventory_components bic,

3117: from
3118: bom_calendar_dates cal,
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

Line 3165: from bom_inventory_components bic1,

3161:
3162: and bic.effectivity_date =
3163: (select
3164: max(effectivity_date)
3165: from bom_inventory_components bic1,
3166: eng_revised_items eri
3167: where bic1.bill_sequence_id = bic.bill_sequence_id
3168: and bic1.component_item_id = bic.component_item_id
3169: and bic1.revised_item_sequence_id =

Line 3187: from bom_inventory_components bicn, eng_revised_items eri1

3183: and ( nvl(eri.status_type,6) IN (4,6,7))
3184: and not exists
3185: (select
3186: 'X'
3187: from bom_inventory_components bicn, eng_revised_items eri1
3188: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
3189: and bicn.old_component_sequence_id =
3190: bic.component_sequence_id
3191: and bicn.acd_type in (2,3)

Line 3423: bom_inventory_components bic,

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

Line 3535: bom_inventory_components bic,

3531: from
3532: bom_calendar_dates cal,
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

Line 3577: from bom_inventory_components bic1,

3573: and nvl(TRUNC(bic.disable_date),(nvl(cal.calendar_date,sysdate) + 1)) > nvl(cal.calendar_date,sysdate)
3574: and bic.effectivity_date =
3575: (select
3576: max(effectivity_date)
3577: from bom_inventory_components bic1,
3578: eng_revised_items eri
3579: where bic1.bill_sequence_id = bic.bill_sequence_id
3580: and bic1.component_item_id = bic.component_item_id
3581: and bic1.revised_item_sequence_id =

Line 3597: from bom_inventory_components bicn, eng_revised_items eri1

3593: and ( nvl(eri.status_type,6) IN (4,6,7))
3594: and not exists
3595: (select
3596: 'X'
3597: from bom_inventory_components bicn, eng_revised_items eri1
3598: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
3599: and bicn.old_component_sequence_id =
3600: bic.component_sequence_id
3601: and bicn.acd_type in (2,3)