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 420: select bom_inventory_components_s.nextval

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

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

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

Line 812: bom_inventory_components ic1,

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

Line 827: bom_inventory_components bic1

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

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

1062: NULL, -- low_quantity
1063: NULL, -- high_quantity
1064: NULL, -- acd_type
1065: NULL, -- old_component_sequence_id
1066: bom_inventory_components_s.nextval, -- component sequence id
1067: lConfigBillId, -- bill sequence id
1068: NULL, -- request_id
1069: NULL, -- program_application_id
1070: NULL, -- program_id

Line 1089: bom_inventory_components ic1

1085: bom_cto_order_lines bcol2, -- Model
1086: mtl_system_items si1,
1087: mtl_system_items si2,
1088: bom_bill_of_materials b,
1089: bom_inventory_components ic1
1090: where si1.organization_id = pOrgId
1091: and bcol1.inventory_item_id = si1.inventory_item_id
1092: and si1.bom_item_type in (1,2) -- model, option class
1093: and si2.inventory_item_id = bcol2.inventory_item_id

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

1926: -- b2307936 : We will insert the base model row irrespective of the OpseqProfile value.
1927:
1928:
1929: /*---------------------------------------------------------------+
1930: Third : Get the base model row into BOM_INVENTORY_COMPONENTS
1931: +----------------------------------------------------------------*/
1932:
1933: lStmtNum := 60;
1934: insert into BOM_INVENTORY_COMPS_INTERFACE

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

2043: NULL, -- low_quantity
2044: NULL, -- high_quantity
2045: NULL, -- acd_type
2046: NULL, -- old_component_sequence_id
2047: bom_inventory_components_s.nextval, -- component sequence id
2048: lConfigBillId, -- bill sequence id
2049: NULL, -- request_id
2050: NULL, -- program_application_id
2051: NULL, -- program_id

Line 2266: from bom_inventory_components bic,

2262: -- bugfix 3985173
2263: -- new cursor for component sequence
2264: cursor club_comp_seq ( xComponentItemId number, xOperation_seq_num number ) is
2265: select bic.component_sequence_id comp_seq_id
2266: from bom_inventory_components bic,
2267: bom_bill_of_materials bom
2268: where bom.assembly_item_id = pConfigId
2269: and bom.organization_id = pOrgId
2270: and bic.bill_sequence_id = bom.bill_sequence_id

Line 2713: bom_inventory_components_s.nextval,

2709: low_quantity,
2710: high_quantity,
2711: acd_type,
2712: old_component_sequence_id,
2713: bom_inventory_components_s.nextval,
2714: request_id,
2715: program_application_id,
2716: program_id,
2717: program_update_date,

Line 3025: Load Bom_inventory_components

3021: oe_debug_pub.add ('create_bom_data_ml: ' || xTableName || '-'|| lStmtNum || ': ' || sql%rowcount, 1 );
3022: END IF;
3023:
3024: /*-----------------------------------------------+
3025: Load Bom_inventory_components
3026: +----------------------------------------------*/
3027: IF PG_DEBUG <> 0 THEN
3028: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
3029: END IF;

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

3024: /*-----------------------------------------------+
3025: Load Bom_inventory_components
3026: +----------------------------------------------*/
3027: IF PG_DEBUG <> 0 THEN
3028: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
3029: END IF;
3030: lStmtNum := 310;
3031: xTableName := 'BOM_INVENTORY_COMPONENTS';
3032: insert into BOM_INVENTORY_COMPONENTS

Line 3031: xTableName := 'BOM_INVENTORY_COMPONENTS';

3027: IF PG_DEBUG <> 0 THEN
3028: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
3029: END IF;
3030: lStmtNum := 310;
3031: xTableName := 'BOM_INVENTORY_COMPONENTS';
3032: insert into BOM_INVENTORY_COMPONENTS
3033: (
3034: operation_seq_num,
3035: component_item_id,

Line 3032: insert into BOM_INVENTORY_COMPONENTS

3028: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
3029: END IF;
3030: lStmtNum := 310;
3031: xTableName := 'BOM_INVENTORY_COMPONENTS';
3032: insert into BOM_INVENTORY_COMPONENTS
3033: (
3034: operation_seq_num,
3035: component_item_id,
3036: last_update_date,

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

3189: /*-----------------------------------------------+
3190: Populate Substitutes for Mandatory components
3191: +----------------------------------------------*/
3192: IF PG_DEBUG <> 0 THEN
3193: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
3194: END IF;
3195: lStmtNum := 315;
3196: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';
3197:

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

3276: ,created_by
3277: ,last_update_login
3278: */
3279:
3280: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s
3281: where b.bill_sequence_id = pConfigBillId
3282: and ABS(b.model_comp_seq_id) = bic.component_sequence_id
3283: and bic.optional = 2 /* only mandatory components */
3284: and bic.component_sequence_id = s.component_sequence_id ;

Line 3390: bom_inventory_components ic,

3386: r.ATTRIBUTE13,
3387: r.ATTRIBUTE14,
3388: r.ATTRIBUTE15
3389: from
3390: bom_inventory_components ic,
3391: bom_reference_designators r,
3392: bom_bill_of_materials b
3393: where b.assembly_item_id = pConfigId
3394: and b.organization_id = pOrgId

Line 3431: bom_inventory_components bic,

3427: -- Determine the component_sequence_id into which this item has been clubbed
3428: select
3429: bic.component_sequence_id into club_component_sequence_id
3430: from
3431: bom_inventory_components bic,
3432: bom_bill_of_materials bom
3433: where bom.assembly_item_id = pConfigId
3434: and bom.organization_id = pOrgId
3435: and bic.bill_sequence_id = bom.bill_sequence_id

Line 3683: bom_inventory_components bc1,

3679: ( select /*+ ORDERED */
3680: NVL(max(v.element_value),i.element_value)
3681: from
3682: bom_bill_of_materials bi,
3683: bom_inventory_components bc1,
3684: bom_inventory_components bc2,
3685: bom_bill_of_materials bi2, -- for model -- BUG 13693029 -- moved for pref
3686: bom_dependent_desc_elements be,
3687: mtl_descr_element_values v

Line 3684: bom_inventory_components bc2,

3680: NVL(max(v.element_value),i.element_value)
3681: from
3682: bom_bill_of_materials bi,
3683: bom_inventory_components bc1,
3684: bom_inventory_components bc2,
3685: bom_bill_of_materials bi2, -- for model -- BUG 13693029 -- moved for pref
3686: bom_dependent_desc_elements be,
3687: mtl_descr_element_values v
3688: where bi.assembly_item_id = pConfigId

Line 3717: bom_inventory_components bc1,

3713: ( select /*+ ORDERED */
3714: NVL(max(v.element_value),i.element_value)
3715: from
3716: bom_bill_of_materials bi,
3717: bom_inventory_components bc1,
3718: bom_inventory_components bc2,
3719: bom_bill_of_materials bi2, -- for model -- BUG 13693029 -- moved for pref
3720: bom_dependent_desc_elements be,
3721: mtl_descr_element_values v

Line 3718: bom_inventory_components bc2,

3714: NVL(max(v.element_value),i.element_value)
3715: from
3716: bom_bill_of_materials bi,
3717: bom_inventory_components bc1,
3718: bom_inventory_components bc2,
3719: bom_bill_of_materials bi2, -- for model -- BUG 13693029 -- moved for pref
3720: bom_dependent_desc_elements be,
3721: mtl_descr_element_values v
3722: where bi.assembly_item_id = pConfigId

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

4030: function inherit_op_seq_ml(
4031: pLineId in oe_order_lines.line_id%TYPE := NULL,
4032: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
4033: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
4034: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
4035: xErrorMessage out NOCOPY VARCHAR2,
4036: xMessageName out NOCOPY VARCHAR2)
4037: return integer is
4038:

Line 4041: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,

4037: return integer is
4038:
4039: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,
4040: xLineId bom_cto_order_lines.line_id%TYPE,
4041: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,
4042: xSchShpdt date,
4043: xEstReldt date ) IS
4044: select bbm.organization_id,
4045: nvl(bic.operation_seq_num,1) operation_seq_num , -- 2433862

Line 4093: bom_inventory_components bic, -- Components

4089: bom_cto_order_lines bcol2, -- MODEL
4090: mtl_system_items si1,
4091: mtl_system_items si2,
4092: bom_bill_of_materials bbm,
4093: bom_inventory_components bic, -- Components
4094: bom_inventory_components bic1, -- Parent
4095: bom_explosion_temp bet
4096: /*-----------------------------------------------------------------------------------------------------+
4097: For a multilevel model , ato_line_id=xLineId will not fetch included items of lower level

Line 4094: bom_inventory_components bic1, -- Parent

4090: mtl_system_items si1,
4091: mtl_system_items si2,
4092: bom_bill_of_materials bbm,
4093: bom_inventory_components bic, -- Components
4094: bom_inventory_components bic1, -- Parent
4095: bom_explosion_temp bet
4096: /*-----------------------------------------------------------------------------------------------------+
4097: For a multilevel model , ato_line_id=xLineId will not fetch included items of lower level
4098: non-phantom models so Parent_ATO_Line_id is used in the join condition.

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

4155: -- and NVL(bic.disable_date,SYSDATE) >= SYSDATE; /* New approach for effectivity dates */
4156: and ( bic.disable_date is null or
4157: (bic.disable_date is not null and bic.disable_date >= sysdate )) ;/* New Approach for Effectivity Dates */
4158:
4159: CURSOR c_model_oc_oi_rows(xConfigBillId bom_inventory_components.bill_sequence_id%TYPE) IS
4160: SELECT /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
4161: nvl(operation_seq_num,1) operation_seq_num, -- 2433862
4162: component_code,
4163: rowid

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

4312: 2, -- required_to_ship = NO
4313: ic1.required_for_revenue,
4314: ic1.include_on_ship_docs,
4315: ic1.include_on_bill_docs,
4316: bom_inventory_components_s.nextval, -- component sequence id
4317: pConfigBillId, -- bill sequence id
4318: ic1.wip_supply_type,
4319: 2, -- pick_components = NO
4320: 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 4335: from bom_inventory_components ic1,

4331: sysdate ),
4332: nvl(ic1.disable_date,g_futuredate) -- 3222932
4333: , nvl(ic1.basis_type,1) /* LBM project */
4334: ,bcol3.inventory_item_id /* Bug Fix : 4147224 */
4335: from bom_inventory_components ic1,
4336: bom_cto_order_lines bcol1, -- Option
4337: bom_cto_order_lines bcol2, -- Parent-Model
4338: bom_cto_order_lines bcol3 , -- Parent-component
4339: mtl_system_items msi_child,

Line 4349: bom_inventory_components bic1

4345: and alternate_bom_designator is null
4346: and assembly_item_id =(
4347: select distinct assembly_item_id
4348: from bom_bill_of_materials bbm1,
4349: bom_inventory_components bic1
4350: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
4351: and component_sequence_id = bcol1.component_sequence_id
4352: and bbm1.assembly_item_id = bcol3.inventory_item_id ))
4353: and ic1.component_item_id = bcol1.inventory_item_id

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

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

Line 4579: bom_inventory_components bic

4575: nvl(bic.disable_date,g_futuredate) -- 3222932
4576: , nvl(bic.basis_type,1) /* LBM project */
4577: from bom_cto_order_lines bcol,
4578: bom_bill_of_materials bbm,
4579: bom_inventory_components bic
4580: where bcol.line_id = pLineId
4581: and bcol.ordered_quantity <> 0
4582: -- bugfix 2389283 and instr(bcol.component_code,'-',1,1) = 0 /* To identify Top Model */
4583: and bcol.inventory_item_id = pModelId

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

4884: 2, -- required_to_ship = NO
4885: r2.required_for_revenue,
4886: r2.include_on_ship_docs,
4887: r2.include_on_bill_docs,
4888: bom_inventory_components_s.nextval, -- component sequence id
4889: pConfigBillId, -- bill sequence id
4890: r2.wip_supply_type,
4891: 2, -- pick_components = NO
4892: (-1)*r2.component_sequence_id, -- model comp seq for later use