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_BOM_PK dependencies on BOM_INVENTORY_COMPONENTS

Line 80: | Failed to insert rows with null op seq num in bom_inventory_components

Line 118: | Accounted for UOM conversion in bom_inventory_components.

114: | Added bill_sequence_id to condition to avoid corrupt data from bom_inventory_comps_interface.
115: |
116: |
117: | ssawant 29-JAN-04 Bugfix 3367823
118: | Accounted for UOM conversion in bom_inventory_components.
119: |
120: |
121: | ssawant 05-FEB-04 Bugfix 3389846
122: | Accounted for disable date greater than EstRelDate, sysdate

Line 186: | Added nvl clause for all insert stmt from bom_inventory_components

Line 187: | to bom_inventory_components_interface

Line 199: | bom_inventory_components table. As per bom team

195: |
196: | Modified by Renga Kannan on 09/07/2005
197: | Bug Fix 4595162
198: | Modified the code that populates basis type to
199: | bom_inventory_components table. As per bom team
200: | basis_type should have null for 'ITEM' and 2 for 'LOT'
201: |
202: |
203: *============================================================================*/

Line 418: select bom_inventory_components_s.nextval

414: oe_debug_pub.add('create_bom_ml: ' || 'Setting Bill ' || lConfigBillId || ' for org ' || pOrgId
415: || ' for line id ' || pLineId , 1);
416: else
417:
418: select bom_inventory_components_s.nextval
419: into lConfigBillId
420: from dual;
421:
422: end if ;

Line 789: bom_inventory_components_s.nextval, -- component sequence id */

785: NULL, -- low_quantity */
786: NULL, -- high_quantity */
787: NULL, -- acd_type */
788: NULL, --old_component_sequence_id */
789: bom_inventory_components_s.nextval, -- component sequence id */
790: lConfigBillId, -- bill sequence id */
791: NULL, -- request_id */
792: NULL, -- program_application_id */
793: NULL, -- program_id */

Line 810: bom_inventory_components ic1,

806: ,bcol3.inventory_item_id /* Bug fix: 4863055 */
807: , nvl(ic1.basis_type,1), /* LBM project */
808: cto_msutil_pub.bom_batch_id
809: from
810: bom_inventory_components ic1,
811: bom_cto_order_lines bcol1, --Option
812: bom_cto_order_lines bcol2, -- Parent-Model
813: bom_cto_order_lines bcol3, -- Parent-component
814: mtl_system_items msi_child ,

Line 825: bom_inventory_components bic1

821: and alternate_bom_designator is null -- on component_item_id. Each component
822: and assembly_item_id =( --is assumed to be used at one operation only
823: select distinct assembly_item_id -- Operation_Seq_num must be same in bills in
824: from bom_bill_of_materials bbm1, -- all organizations for that assembly
825: bom_inventory_components bic1
826: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
827: and component_sequence_id = bcol1.component_sequence_id
828: and bbm1.assembly_item_id = bcol3.inventory_item_id ))
829: and ic1.component_item_id = bcol1.inventory_item_id

Line 1041: bom_inventory_components_s.nextval, -- component sequence id

1037: NULL, -- low_quantity
1038: NULL, -- high_quantity
1039: NULL, -- acd_type
1040: NULL, -- old_component_sequence_id
1041: bom_inventory_components_s.nextval, -- component sequence id
1042: lConfigBillId, -- bill sequence id
1043: NULL, -- request_id
1044: NULL, -- program_application_id
1045: NULL, -- program_id

Line 1064: bom_inventory_components ic1

1060: bom_cto_order_lines bcol2, -- Model
1061: mtl_system_items si1,
1062: mtl_system_items si2,
1063: bom_bill_of_materials b,
1064: bom_inventory_components ic1
1065: where si1.organization_id = pOrgId
1066: and bcol1.inventory_item_id = si1.inventory_item_id
1067: and si1.bom_item_type in (1,2) -- model, option class
1068: and si2.inventory_item_id = bcol2.inventory_item_id

Line 1904: Third : Get the base model row into BOM_INVENTORY_COMPONENTS

1900: -- b2307936 : We will insert the base model row irrespective of the OpseqProfile value.
1901:
1902:
1903: /*---------------------------------------------------------------+
1904: Third : Get the base model row into BOM_INVENTORY_COMPONENTS
1905: +----------------------------------------------------------------*/
1906:
1907: lStmtNum := 60;
1908: insert into BOM_INVENTORY_COMPS_INTERFACE

Line 2021: bom_inventory_components_s.nextval, -- component sequence id

2017: NULL, -- low_quantity
2018: NULL, -- high_quantity
2019: NULL, -- acd_type
2020: NULL, -- old_component_sequence_id
2021: bom_inventory_components_s.nextval, -- component sequence id
2022: lConfigBillId, -- bill sequence id
2023: NULL, -- request_id
2024: NULL, -- program_application_id
2025: NULL, -- program_id

Line 2226: from bom_inventory_components bic,

2222: -- bugfix 3985173
2223: -- new cursor for component sequence
2224: cursor club_comp_seq ( xComponentItemId number, xOperation_seq_num number ) is
2225: select bic.component_sequence_id comp_seq_id
2226: from bom_inventory_components bic,
2227: bom_bill_of_materials bom
2228: where bom.assembly_item_id = pConfigId
2229: and bom.organization_id = pOrgId
2230: and bic.bill_sequence_id = bom.bill_sequence_id

Line 2653: bom_inventory_components_s.nextval,

2649: low_quantity,
2650: high_quantity,
2651: acd_type,
2652: old_component_sequence_id,
2653: bom_inventory_components_s.nextval,
2654: request_id,
2655: program_application_id,
2656: program_id,
2657: program_update_date,

Line 2957: Load Bom_inventory_components

2953: oe_debug_pub.add ('create_bom_data_ml: ' || xTableName || '-'|| lStmtNum || ': ' || sql%rowcount, 1 );
2954: END IF;
2955:
2956: /*-----------------------------------------------+
2957: Load Bom_inventory_components
2958: +----------------------------------------------*/
2959: IF PG_DEBUG <> 0 THEN
2960: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
2961: END IF;

Line 2960: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);

2956: /*-----------------------------------------------+
2957: Load Bom_inventory_components
2958: +----------------------------------------------*/
2959: IF PG_DEBUG <> 0 THEN
2960: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
2961: END IF;
2962: lStmtNum := 310;
2963: xTableName := 'BOM_INVENTORY_COMPONENTS';
2964: insert into BOM_INVENTORY_COMPONENTS

Line 2963: xTableName := 'BOM_INVENTORY_COMPONENTS';

2959: IF PG_DEBUG <> 0 THEN
2960: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
2961: END IF;
2962: lStmtNum := 310;
2963: xTableName := 'BOM_INVENTORY_COMPONENTS';
2964: insert into BOM_INVENTORY_COMPONENTS
2965: (
2966: operation_seq_num,
2967: component_item_id,

Line 2964: insert into BOM_INVENTORY_COMPONENTS

2960: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
2961: END IF;
2962: lStmtNum := 310;
2963: xTableName := 'BOM_INVENTORY_COMPONENTS';
2964: insert into BOM_INVENTORY_COMPONENTS
2965: (
2966: operation_seq_num,
2967: component_item_id,
2968: last_update_date,

Line 3117: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);

3113: /*-----------------------------------------------+
3114: Populate Substitutes for Mandatory components
3115: +----------------------------------------------*/
3116: IF PG_DEBUG <> 0 THEN
3117: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
3118: END IF;
3119: lStmtNum := 315;
3120: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';
3121:

Line 3204: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s

3200: ,created_by
3201: ,last_update_login
3202: */
3203:
3204: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s
3205: where b.bill_sequence_id = pConfigBillId
3206: and ABS(b.model_comp_seq_id) = bic.component_sequence_id
3207: and bic.optional = 2 /* only mandatory components */
3208: and bic.component_sequence_id = s.component_sequence_id ;

Line 3306: bom_inventory_components ic,

3302: r.ATTRIBUTE13,
3303: r.ATTRIBUTE14,
3304: r.ATTRIBUTE15
3305: from
3306: bom_inventory_components ic,
3307: bom_reference_designators r,
3308: bom_bill_of_materials b
3309: where b.assembly_item_id = pConfigId
3310: and b.organization_id = pOrgId

Line 3347: bom_inventory_components bic,

3343: -- Determine the component_sequence_id into which this item has been clubbed
3344: select
3345: bic.component_sequence_id into club_component_sequence_id
3346: from
3347: bom_inventory_components bic,
3348: bom_bill_of_materials bom
3349: where bom.assembly_item_id = pConfigId
3350: and bom.organization_id = pOrgId
3351: and bic.bill_sequence_id = bom.bill_sequence_id

Line 3591: bom_inventory_components bc1,

3587: ( select /*+ ORDERED */
3588: NVL(max(v.element_value),i.element_value)
3589: from
3590: bom_bill_of_materials bi,
3591: bom_inventory_components bc1,
3592: bom_inventory_components bc2,
3593: bom_dependent_desc_elements be,
3594: mtl_descr_element_values v
3595: where bi.assembly_item_id = pConfigId

Line 3592: bom_inventory_components bc2,

3588: NVL(max(v.element_value),i.element_value)
3589: from
3590: bom_bill_of_materials bi,
3591: bom_inventory_components bc1,
3592: bom_inventory_components bc2,
3593: bom_dependent_desc_elements be,
3594: mtl_descr_element_values v
3595: where bi.assembly_item_id = pConfigId
3596: and bi.organization_id = pOrgId

Line 3621: bom_inventory_components bc1,

3617: ( select /*+ ORDERED */
3618: NVL(max(v.element_value),i.element_value)
3619: from
3620: bom_bill_of_materials bi,
3621: bom_inventory_components bc1,
3622: bom_inventory_components bc2,
3623: bom_dependent_desc_elements be,
3624: mtl_descr_element_values v
3625: where bi.assembly_item_id = pConfigId

Line 3622: bom_inventory_components bc2,

3618: NVL(max(v.element_value),i.element_value)
3619: from
3620: bom_bill_of_materials bi,
3621: bom_inventory_components bc1,
3622: bom_inventory_components bc2,
3623: bom_dependent_desc_elements be,
3624: mtl_descr_element_values v
3625: where bi.assembly_item_id = pConfigId
3626: and bi.organization_id = pOrgId

Line 3855: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,

3851: function inherit_op_seq_ml(
3852: pLineId in oe_order_lines.line_id%TYPE := NULL,
3853: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
3854: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
3855: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
3856: xErrorMessage out NOCOPY VARCHAR2,
3857: xMessageName out NOCOPY VARCHAR2)
3858: return integer is
3859:

Line 3862: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,

3858: return integer is
3859:
3860: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,
3861: xLineId bom_cto_order_lines.line_id%TYPE,
3862: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,
3863: xSchShpdt date,
3864: xEstReldt date ) IS
3865: select bbm.organization_id,
3866: nvl(bic.operation_seq_num,1) operation_seq_num , -- 2433862

Line 3914: bom_inventory_components bic, -- Components

3910: bom_cto_order_lines bcol2, -- MODEL
3911: mtl_system_items si1,
3912: mtl_system_items si2,
3913: bom_bill_of_materials bbm,
3914: bom_inventory_components bic, -- Components
3915: bom_inventory_components bic1, -- Parent
3916: bom_explosion_temp bet
3917: /*-----------------------------------------------------------------------------------------------------+
3918: For a multilevel model , ato_line_id=xLineId will not fetch included items of lower level

Line 3915: bom_inventory_components bic1, -- Parent

3911: mtl_system_items si1,
3912: mtl_system_items si2,
3913: bom_bill_of_materials bbm,
3914: bom_inventory_components bic, -- Components
3915: bom_inventory_components bic1, -- Parent
3916: bom_explosion_temp bet
3917: /*-----------------------------------------------------------------------------------------------------+
3918: For a multilevel model , ato_line_id=xLineId will not fetch included items of lower level
3919: non-phantom models so Parent_ATO_Line_id is used in the join condition.

Line 3980: CURSOR c_model_oc_oi_rows(xConfigBillId bom_inventory_components.bill_sequence_id%TYPE) IS

3976: -- and NVL(bic.disable_date,SYSDATE) >= SYSDATE; /* New approach for effectivity dates */
3977: and ( bic.disable_date is null or
3978: (bic.disable_date is not null and bic.disable_date >= sysdate )) ;/* New Approach for Effectivity Dates */
3979:
3980: CURSOR c_model_oc_oi_rows(xConfigBillId bom_inventory_components.bill_sequence_id%TYPE) IS
3981: SELECT /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
3982: nvl(operation_seq_num,1) operation_seq_num, -- 2433862
3983: component_code,
3984: rowid

Line 4133: bom_inventory_components_s.nextval, -- component sequence id

4129: 2, -- required_to_ship = NO
4130: ic1.required_for_revenue,
4131: ic1.include_on_ship_docs,
4132: ic1.include_on_bill_docs,
4133: bom_inventory_components_s.nextval, -- component sequence id
4134: pConfigBillId, -- bill sequence id
4135: ic1.wip_supply_type,
4136: 2, -- pick_components = NO
4137: decode(bcol1.config_item_id, NULL, (-1)*ic1.component_sequence_id, ic1.component_sequence_id), -- saved model comp seq for later use. If config item, then save model comp seq id as positive, otherwise negative.

Line 4152: from bom_inventory_components ic1,

4148: sysdate ),
4149: nvl(ic1.disable_date,g_futuredate) -- 3222932
4150: , nvl(ic1.basis_type,1) /* LBM project */
4151: ,bcol3.inventory_item_id /* Bug Fix : 4147224 */
4152: from bom_inventory_components ic1,
4153: bom_cto_order_lines bcol1, -- Option
4154: bom_cto_order_lines bcol2, -- Parent-Model
4155: bom_cto_order_lines bcol3 , -- Parent-component
4156: mtl_system_items msi_child,

Line 4166: bom_inventory_components bic1

4162: and alternate_bom_designator is null
4163: and assembly_item_id =(
4164: select distinct assembly_item_id
4165: from bom_bill_of_materials bbm1,
4166: bom_inventory_components bic1
4167: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
4168: and component_sequence_id = bcol1.component_sequence_id
4169: and bbm1.assembly_item_id = bcol3.inventory_item_id ))
4170: and ic1.component_item_id = bcol1.inventory_item_id

Line 4373: bom_inventory_components_s.nextval, -- component sequence id

4369: 2, -- required_to_ship = NO
4370: bic.required_for_revenue,
4371: bic.include_on_ship_docs,
4372: bic.include_on_bill_docs,
4373: bom_inventory_components_s.nextval, -- component sequence id
4374: pConfigBillId, -- bill sequence id
4375: bic.wip_supply_type,
4376: 2, -- pick_components = NO
4377: (-1)*bic.component_sequence_id, -- model comp seq for later use

Line 4391: bom_inventory_components bic

4387: nvl(bic.disable_date,g_futuredate) -- 3222932
4388: , nvl(bic.basis_type,1) /* LBM project */
4389: from bom_cto_order_lines bcol,
4390: bom_bill_of_materials bbm,
4391: bom_inventory_components bic
4392: where bcol.line_id = pLineId
4393: and bcol.ordered_quantity <> 0
4394: -- bugfix 2389283 and instr(bcol.component_code,'-',1,1) = 0 /* To identify Top Model */
4395: and bcol.inventory_item_id = pModelId

Line 4561: bom_inventory_components_s.nextval, -- component sequence id

4557: 2, -- required_to_ship = NO
4558: r2.required_for_revenue,
4559: r2.include_on_ship_docs,
4560: r2.include_on_bill_docs,
4561: bom_inventory_components_s.nextval, -- component sequence id
4562: pConfigBillId, -- bill sequence id
4563: r2.wip_supply_type,
4564: 2, -- pick_components = NO
4565: (-1)*r2.component_sequence_id, -- model comp seq for later use