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_UPDATE_BOM_RTG_PK dependencies on BOM_BILL_OF_MATERIALS

Line 69: | bom_bill_of_materials view.

Line 121: g_structure_type_id bom_bill_of_materials.structure_type_id%type ;

117: gLoginId number := nvl(Fnd_Global.LOGIN_ID, -1);
118: */
119:
120: -- bug 4271269. populate structure_type_id in BOM
121: g_structure_type_id bom_bill_of_materials.structure_type_id%type ;
122:
123: gUserId number := nvl(fnd_global.user_id, -1);
124: gLoginId number := nvl(fnd_global.login_id, -1);
125: gRequestId number := nvl(fnd_global.conc_request_id, -1) ;

Line 1136: bom_bill_of_materials bom

1132: -- new cursor for component sequence
1133: cursor club_comp_seq ( xComponentItemId number, xOperation_seq_num number ) is
1134: select bic.component_sequence_id comp_seq_id
1135: from bom_inventory_components bic,
1136: bom_bill_of_materials bom
1137: where bom.assembly_item_id = pConfigId
1138: and bom.organization_id = pOrgId
1139: and bic.bill_sequence_id = bom.bill_sequence_id
1140: and bic.component_item_id = xComponentItemId

Line 1432: from bom_bill_of_materials bbm

1428: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1429: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1430: where ic1.bill_sequence_id = (
1431: select common_bill_sequence_id
1432: from bom_bill_of_materials bbm
1433: where organization_id = pOrgId
1434: and alternate_bom_designator is null
1435: and assembly_item_id =(
1436: select distinct assembly_item_id

Line 1437: from bom_bill_of_materials bbm1,

1433: where organization_id = pOrgId
1434: and alternate_bom_designator is null
1435: and assembly_item_id =(
1436: select distinct assembly_item_id
1437: from bom_bill_of_materials bbm1,
1438: bom_inventory_components bic1
1439: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
1440: and component_sequence_id = bcol1.component_sequence_id
1441: and bbm1.assembly_item_id = bcol3.inventory_item_id ))

Line 1671: bom_bill_of_materials b,

1667: bom_cto_order_lines_upg bcol1, -- component
1668: bom_cto_order_lines_upg bcol2, -- Model
1669: mtl_system_items si1,
1670: mtl_system_items si2,
1671: bom_bill_of_materials b,
1672: bom_inventory_components ic1
1673: where si1.organization_id = pOrgId
1674: and bcol1.inventory_item_id = si1.inventory_item_id
1675: and si1.bom_item_type in (1,2) -- model, option class

Line 2589: bom_bill_of_materials b1,

2585: bom_cto_order_lines_upg bcol1, -- components
2586: bom_cto_order_lines_upg bcol2, -- parent models or option classes
2587: mtl_system_items msi,
2588: bom_inventory_components ic1,
2589: bom_bill_of_materials b1,
2590: bom_operational_routings or1,
2591: bom_operation_sequences os1
2592: where bcol1.parent_ato_line_id = pLineId /*AP*/
2593: and bcol1.item_type_code in ('CLASS','OPTION') /* OC and Option items */

Line 2603: from bom_bill_of_materials bbm

2599: and bcol2.ordered_quantity <> 0
2600: and bcol2.line_id = bcol1.link_to_line_id
2601: and ic1.bill_sequence_id = (
2602: select common_bill_sequence_id
2603: from bom_bill_of_materials bbm
2604: where organization_id = pOrgId
2605: and alternate_bom_designator is null
2606: and assembly_item_id =(
2607: select distinct assembly_item_id

Line 2608: from bom_bill_of_materials bbm1,

2604: where organization_id = pOrgId
2605: and alternate_bom_designator is null
2606: and assembly_item_id =(
2607: select distinct assembly_item_id
2608: from bom_bill_of_materials bbm1,
2609: bom_inventory_components bic1
2610: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
2611: and component_sequence_id = bcol1.component_sequence_id
2612: and bbm1.assembly_item_id = bcol2.inventory_item_id ))

Line 2654: bom_bill_of_materials b1,

2650: bom_operation_sequences os1,
2651: bom_operational_routings or1,
2652: mtl_system_items si2,
2653: bom_inventory_components ic1,
2654: bom_bill_of_materials b1,
2655: mtl_system_items si1
2656: where si1.organization_id = pOrgId
2657: and si1.inventory_item_id = pModelId
2658: and si1.bom_item_type = 1 /* model */

Line 3009: bom_bill_of_materials b1,

3005: from
3006: bom_cto_order_lines_upg bcol1, /* components */
3007: bom_cto_order_lines_upg bcol2, /* parents model */
3008: bom_inventory_components ic1,
3009: bom_bill_of_materials b1,
3010: bom_operational_routings or1,
3011: bom_operation_sequences os1
3012: where bcol1.parent_ato_line_id = pLineId
3013: and bcol1.item_type_code in ('CLASS','OPTION')

Line 3021: from bom_bill_of_materials bbm

3017: and bcol2.ordered_quantity <> 0
3018: and bcol2.line_id = bcol1.link_to_line_id
3019: and ic1.bill_sequence_id = (
3020: select common_bill_sequence_id
3021: from bom_bill_of_materials bbm
3022: where organization_id = pOrgId
3023: and alternate_bom_designator is null
3024: and assembly_item_id =(
3025: select distinct assembly_item_id

Line 3026: from bom_bill_of_materials bbm1,

3022: where organization_id = pOrgId
3023: and alternate_bom_designator is null
3024: and assembly_item_id =(
3025: select distinct assembly_item_id
3026: from bom_bill_of_materials bbm1,
3027: bom_inventory_components bic1
3028: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
3029: and component_sequence_id = bcol1.component_sequence_id
3030: and bbm1.assembly_item_id = bcol2.inventory_item_id ))

Line 3071: bom_bill_of_materials b1,

3067: bom_operation_sequences os1,
3068: bom_operational_routings or1,
3069: mtl_system_items si2,
3070: bom_inventory_components ic1,
3071: bom_bill_of_materials b1,
3072: mtl_system_items si1,
3073: bom_cto_order_lines_upg bcol /* Model or option class */
3074: where bcol.parent_ato_line_id = pLineId
3075: and bcol.component_sequence_id is not null

Line 4346: from bom_bill_of_materials

4342: -- get bill_sequence_id of top model
4343: --
4344: select common_bill_sequence_id
4345: into p_bill_seq_id
4346: from bom_bill_of_materials
4347: where assembly_item_id =
4348: (select component_item_id
4349: from bom_inventory_comps_interface
4350: where bill_sequence_id = lConfigBillId and parent_bill_seq_id = 0) /* Introduced by sushant */

Line 4368: Load BOM_bill_of_materials

4364: p_seq_increment);
4365:
4366:
4367: /*-------------------------------------------+
4368: Load BOM_bill_of_materials
4369: +-------------------------------------------*/
4370: WriteToLog('Before first insert into bill_of_materials.' ,3);
4371: WriteToLog('Org: ' ||to_char(pOrgId), 4);
4372: WriteToLog('Model: ' || to_char(pModelId), 4);

Line 4417: xTableName := 'BOM_BILL_OF_MATERIALS';

4413: -- So far these two columns are populated thru database trigger
4414: -- bom is planning on droping this trigger in R12, hence we need
4415:
4416: lStmtNum := 145;
4417: xTableName := 'BOM_BILL_OF_MATERIALS';
4418: insert into BOM_BILL_OF_MATERIALS(
4419: assembly_item_id,
4420: organization_id,
4421: alternate_bom_designator,

Line 4418: insert into BOM_BILL_OF_MATERIALS(

4414: -- bom is planning on droping this trigger in R12, hence we need
4415:
4416: lStmtNum := 145;
4417: xTableName := 'BOM_BILL_OF_MATERIALS';
4418: insert into BOM_BILL_OF_MATERIALS(
4419: assembly_item_id,
4420: organization_id,
4421: alternate_bom_designator,
4422: last_update_date,

Line 4507: from bom_bill_of_materials b

4503: g_structure_type_id, -- bugfix 4271269 structure_type_id
4504: 1, -- bugfix 4271269 effectivity_control
4505: pconfigid,
4506: porgid
4507: from bom_bill_of_materials b
4508: where b.assembly_item_id = pModelId
4509: and b.organization_id = pOrgId
4510: and b.alternate_bom_designator is NULL;
4511:

Line 4512: WriteToLog('Inserted rows into bom_bill_of_materials::'||sql%rowcount, 2 );

4508: where b.assembly_item_id = pModelId
4509: and b.organization_id = pOrgId
4510: and b.alternate_bom_designator is NULL;
4511:
4512: WriteToLog('Inserted rows into bom_bill_of_materials::'||sql%rowcount, 2 );
4513:
4514: /*-----------------------------------------------+
4515: Load Bom_inventory_components
4516: +----------------------------------------------*/

Line 4892: bom_bill_of_materials b

4888: r.ATTRIBUTE15
4889: from
4890: bom_inventory_components ic,
4891: bom_reference_designators r,
4892: bom_bill_of_materials b
4893: where b.assembly_item_id = pConfigId
4894: and b.organization_id = pOrgId
4895: and ic.bill_sequence_id = b.bill_sequence_id
4896: and r.component_sequence_id = abs(ic.model_comp_seq_id) -- previously last_update_login

Line 4932: bom_bill_of_materials bom

4928: select
4929: bic.component_sequence_id into club_component_sequence_id
4930: from
4931: bom_inventory_components bic,
4932: bom_bill_of_materials bom
4933: where bom.assembly_item_id = pConfigId
4934: and bom.organization_id = pOrgId
4935: and bic.bill_sequence_id = bom.bill_sequence_id
4936: and bic.component_item_id = component_item_id_arr(x1);

Line 5160: bom_bill_of_materials bi,

5156: set i.element_value =
5157: ( select /*+ ORDERED */
5158: NVL(max(v.element_value),i.element_value)
5159: from
5160: bom_bill_of_materials bi,
5161: bom_inventory_components bc1,
5162: bom_inventory_components bc2,
5163: bom_dependent_desc_elements be,
5164: mtl_descr_element_values v

Line 5188: bom_bill_of_materials bi,

5184: set i.element_value =
5185: ( select /*+ ORDERED */
5186: NVL(max(v.element_value),i.element_value)
5187: from
5188: bom_bill_of_materials bi,
5189: bom_inventory_components bc1,
5190: bom_inventory_components bc2,
5191: bom_dependent_desc_elements be,
5192: mtl_descr_element_values v

Line 5245: from bom_bill_of_materials

5241:
5242: lStmtNum := 360;
5243: select common_bill_sequence_id
5244: into l_from_sequence_id
5245: from bom_bill_of_materials
5246: where assembly_item_id = pModelId
5247: and organization_id = pOrgId
5248: and alternate_bom_designator is NULL;
5249:

Line 5252: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',

5248: and alternate_bom_designator is NULL;
5249:
5250: lStmtNum := 370;
5251: fnd_attached_documents2_pkg.copy_attachments(
5252: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',
5253: X_from_pk1_value => l_from_sequence_id,
5254: X_from_pk2_value => '',
5255: X_from_pk3_value => '',
5256: X_from_pk4_value => '',

Line 5258: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',

5254: X_from_pk2_value => '',
5255: X_from_pk3_value => '',
5256: X_from_pk4_value => '',
5257: X_from_pk5_value => '',
5258: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',
5259: X_to_pk1_value => lConfigBillId,
5260: X_to_pk2_value => '',
5261: X_to_pk3_value => '',
5262: X_to_pk4_value => '',

Line 5835: from bom_bill_of_materials

5831: BEGIN
5832:
5833: select common_bill_sequence_id
5834: into p_bill_seq_id
5835: from bom_bill_of_materials
5836: where assembly_item_id = v_update_item_num.component_item_id
5837: and organization_id = p_org_id
5838: and alternate_bom_designator is null;
5839:

Line 5868: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,

5864:
5865: FUNCTION inherit_op_seq_ml(
5866: pLineId in oe_order_lines.line_id%TYPE := NULL,
5867: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
5868: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
5869: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
5870: xErrorMessage out NOCOPY VARCHAR2,
5871: xMessageName out NOCOPY VARCHAR2)
5872: RETURN INTEGER IS

Line 5927: bom_bill_of_materials bbm,

5923: from bom_cto_order_lines_upg bcol1, -- COMPONENT
5924: bom_cto_order_lines_upg bcol2, -- MODEL
5925: mtl_system_items si1,
5926: mtl_system_items si2,
5927: bom_bill_of_materials bbm,
5928: bom_inventory_components bic, -- Components
5929: bom_inventory_components bic1, -- Parent
5930: bom_explosion_temp bet
5931: where bcol1.parent_ato_line_id = xLineId

Line 6139: from bom_bill_of_materials bbm

6135: mtl_system_items msi_child,
6136: mtl_system_items msi_parent
6137: where ic1.bill_sequence_id = (
6138: select common_bill_sequence_id
6139: from bom_bill_of_materials bbm
6140: where organization_id = pOrgId
6141: and alternate_bom_designator is null
6142: and assembly_item_id =(
6143: select distinct assembly_item_id

Line 6144: from bom_bill_of_materials bbm1,

6140: where organization_id = pOrgId
6141: and alternate_bom_designator is null
6142: and assembly_item_id =(
6143: select distinct assembly_item_id
6144: from bom_bill_of_materials bbm1,
6145: bom_inventory_components bic1
6146: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
6147: and component_sequence_id = bcol1.component_sequence_id
6148: and bbm1.assembly_item_id = bcol3.inventory_item_id ))

Line 6333: bom_bill_of_materials bbm,

6329: sysdate ),
6330: nvl(bic.disable_date,g_futuredate) -- 3222932
6331: , nvl(bic.basis_type,1) /* LBM project */
6332: from bom_cto_order_lines_upg bcol,
6333: bom_bill_of_materials bbm,
6334: bom_inventory_components bic
6335: where bcol.line_id = pLineId
6336: and bcol.ordered_quantity <> 0
6337: -- bugfix 2389283 and instr(bcol.component_code,'-',1,1) = 0 /* To identify Top Model */

Line 6823: from bom_bill_of_materials

6819: WriteToLog('Check_bom:Before check_bom sql::xBillId:: '||to_char(xBillId ), 5);
6820:
6821: select bill_sequence_id
6822: into xBillId
6823: from bom_bill_of_materials
6824: where assembly_item_id = pItemId
6825: and organization_id = pOrgId
6826: and alternate_bom_designator is null;
6827: