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.

[Home] [Help]

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 1077: bom_bill_of_materials bom

1073: -- new cursor for component sequence
1074: cursor club_comp_seq ( xComponentItemId number, xOperation_seq_num number ) is
1075: select bic.component_sequence_id comp_seq_id
1076: from bom_inventory_components bic,
1077: bom_bill_of_materials bom
1078: where bom.assembly_item_id = pConfigId
1079: and bom.organization_id = pOrgId
1080: and bic.bill_sequence_id = bom.bill_sequence_id
1081: and bic.component_item_id = xComponentItemId

Line 1373: from bom_bill_of_materials bbm

1369: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1370: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1371: where ic1.bill_sequence_id = (
1372: select common_bill_sequence_id
1373: from bom_bill_of_materials bbm
1374: where organization_id = pOrgId
1375: and alternate_bom_designator is null
1376: and assembly_item_id =(
1377: select distinct assembly_item_id

Line 1378: from bom_bill_of_materials bbm1,

1374: where organization_id = pOrgId
1375: and alternate_bom_designator is null
1376: and assembly_item_id =(
1377: select distinct assembly_item_id
1378: from bom_bill_of_materials bbm1,
1379: bom_inventory_components bic1
1380: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
1381: and component_sequence_id = bcol1.component_sequence_id
1382: and bbm1.assembly_item_id = bcol3.inventory_item_id ))

Line 1612: bom_bill_of_materials b,

1608: bom_cto_order_lines_upg bcol1, -- component
1609: bom_cto_order_lines_upg bcol2, -- Model
1610: mtl_system_items si1,
1611: mtl_system_items si2,
1612: bom_bill_of_materials b,
1613: bom_inventory_components ic1
1614: where si1.organization_id = pOrgId
1615: and bcol1.inventory_item_id = si1.inventory_item_id
1616: and si1.bom_item_type in (1,2) -- model, option class

Line 2500: bom_bill_of_materials b1,

2496: bom_cto_order_lines_upg bcol1, -- components
2497: bom_cto_order_lines_upg bcol2, -- parent models or option classes
2498: mtl_system_items msi,
2499: bom_inventory_components ic1,
2500: bom_bill_of_materials b1,
2501: bom_operational_routings or1,
2502: bom_operation_sequences os1
2503: where bcol1.parent_ato_line_id = pLineId /*AP*/
2504: and bcol1.item_type_code in ('CLASS','OPTION') /* OC and Option items */

Line 2514: from bom_bill_of_materials bbm

2510: and bcol2.ordered_quantity <> 0
2511: and bcol2.line_id = bcol1.link_to_line_id
2512: and ic1.bill_sequence_id = (
2513: select common_bill_sequence_id
2514: from bom_bill_of_materials bbm
2515: where organization_id = pOrgId
2516: and alternate_bom_designator is null
2517: and assembly_item_id =(
2518: select distinct assembly_item_id

Line 2519: from bom_bill_of_materials bbm1,

2515: where organization_id = pOrgId
2516: and alternate_bom_designator is null
2517: and assembly_item_id =(
2518: select distinct assembly_item_id
2519: from bom_bill_of_materials bbm1,
2520: bom_inventory_components bic1
2521: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
2522: and component_sequence_id = bcol1.component_sequence_id
2523: and bbm1.assembly_item_id = bcol2.inventory_item_id ))

Line 2565: bom_bill_of_materials b1,

2561: bom_operation_sequences os1,
2562: bom_operational_routings or1,
2563: mtl_system_items si2,
2564: bom_inventory_components ic1,
2565: bom_bill_of_materials b1,
2566: mtl_system_items si1
2567: where si1.organization_id = pOrgId
2568: and si1.inventory_item_id = pModelId
2569: and si1.bom_item_type = 1 /* model */

Line 2920: bom_bill_of_materials b1,

2916: from
2917: bom_cto_order_lines_upg bcol1, /* components */
2918: bom_cto_order_lines_upg bcol2, /* parents model */
2919: bom_inventory_components ic1,
2920: bom_bill_of_materials b1,
2921: bom_operational_routings or1,
2922: bom_operation_sequences os1
2923: where bcol1.parent_ato_line_id = pLineId
2924: and bcol1.item_type_code in ('CLASS','OPTION')

Line 2932: from bom_bill_of_materials bbm

2928: and bcol2.ordered_quantity <> 0
2929: and bcol2.line_id = bcol1.link_to_line_id
2930: and ic1.bill_sequence_id = (
2931: select common_bill_sequence_id
2932: from bom_bill_of_materials bbm
2933: where organization_id = pOrgId
2934: and alternate_bom_designator is null
2935: and assembly_item_id =(
2936: select distinct assembly_item_id

Line 2937: from bom_bill_of_materials bbm1,

2933: where organization_id = pOrgId
2934: and alternate_bom_designator is null
2935: and assembly_item_id =(
2936: select distinct assembly_item_id
2937: from bom_bill_of_materials bbm1,
2938: bom_inventory_components bic1
2939: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
2940: and component_sequence_id = bcol1.component_sequence_id
2941: and bbm1.assembly_item_id = bcol2.inventory_item_id ))

Line 2982: bom_bill_of_materials b1,

2978: bom_operation_sequences os1,
2979: bom_operational_routings or1,
2980: mtl_system_items si2,
2981: bom_inventory_components ic1,
2982: bom_bill_of_materials b1,
2983: mtl_system_items si1,
2984: bom_cto_order_lines_upg bcol /* Model or option class */
2985: where bcol.parent_ato_line_id = pLineId
2986: and bcol.component_sequence_id is not null

Line 4179: from bom_bill_of_materials

4175: -- get bill_sequence_id of top model
4176: --
4177: select common_bill_sequence_id
4178: into p_bill_seq_id
4179: from bom_bill_of_materials
4180: where assembly_item_id =
4181: (select component_item_id
4182: from bom_inventory_comps_interface
4183: where bill_sequence_id = lConfigBillId and parent_bill_seq_id = 0) /* Introduced by sushant */

Line 4201: Load BOM_bill_of_materials

4197: p_seq_increment);
4198:
4199:
4200: /*-------------------------------------------+
4201: Load BOM_bill_of_materials
4202: +-------------------------------------------*/
4203: WriteToLog('Before first insert into bill_of_materials.' ,3);
4204: WriteToLog('Org: ' ||to_char(pOrgId), 4);
4205: WriteToLog('Model: ' || to_char(pModelId), 4);

Line 4250: xTableName := 'BOM_BILL_OF_MATERIALS';

4246: -- So far these two columns are populated thru database trigger
4247: -- bom is planning on droping this trigger in R12, hence we need
4248:
4249: lStmtNum := 145;
4250: xTableName := 'BOM_BILL_OF_MATERIALS';
4251: insert into BOM_BILL_OF_MATERIALS(
4252: assembly_item_id,
4253: organization_id,
4254: alternate_bom_designator,

Line 4251: insert into BOM_BILL_OF_MATERIALS(

4247: -- bom is planning on droping this trigger in R12, hence we need
4248:
4249: lStmtNum := 145;
4250: xTableName := 'BOM_BILL_OF_MATERIALS';
4251: insert into BOM_BILL_OF_MATERIALS(
4252: assembly_item_id,
4253: organization_id,
4254: alternate_bom_designator,
4255: last_update_date,

Line 4332: from bom_bill_of_materials b

4328: g_structure_type_id, -- bugfix 4271269 structure_type_id
4329: 1, -- bugfix 4271269 effectivity_control
4330: pconfigid,
4331: porgid
4332: from bom_bill_of_materials b
4333: where b.assembly_item_id = pModelId
4334: and b.organization_id = pOrgId
4335: and b.alternate_bom_designator is NULL;
4336:

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

4333: where b.assembly_item_id = pModelId
4334: and b.organization_id = pOrgId
4335: and b.alternate_bom_designator is NULL;
4336:
4337: WriteToLog('Inserted rows into bom_bill_of_materials::'||sql%rowcount, 2 );
4338:
4339: /*-----------------------------------------------+
4340: Load Bom_inventory_components
4341: +----------------------------------------------*/

Line 4701: bom_bill_of_materials b

4697: r.ATTRIBUTE15
4698: from
4699: bom_inventory_components ic,
4700: bom_reference_designators r,
4701: bom_bill_of_materials b
4702: where b.assembly_item_id = pConfigId
4703: and b.organization_id = pOrgId
4704: and ic.bill_sequence_id = b.bill_sequence_id
4705: and r.component_sequence_id = abs(ic.model_comp_seq_id) -- previously last_update_login

Line 4741: bom_bill_of_materials bom

4737: select
4738: bic.component_sequence_id into club_component_sequence_id
4739: from
4740: bom_inventory_components bic,
4741: bom_bill_of_materials bom
4742: where bom.assembly_item_id = pConfigId
4743: and bom.organization_id = pOrgId
4744: and bic.bill_sequence_id = bom.bill_sequence_id
4745: and bic.component_item_id = component_item_id_arr(x1);

Line 4961: bom_bill_of_materials bi,

4957: set i.element_value =
4958: ( select /*+ ORDERED */
4959: NVL(max(v.element_value),i.element_value)
4960: from
4961: bom_bill_of_materials bi,
4962: bom_inventory_components bc1,
4963: bom_inventory_components bc2,
4964: bom_dependent_desc_elements be,
4965: mtl_descr_element_values v

Line 4989: bom_bill_of_materials bi,

4985: set i.element_value =
4986: ( select /*+ ORDERED */
4987: NVL(max(v.element_value),i.element_value)
4988: from
4989: bom_bill_of_materials bi,
4990: bom_inventory_components bc1,
4991: bom_inventory_components bc2,
4992: bom_dependent_desc_elements be,
4993: mtl_descr_element_values v

Line 5046: from bom_bill_of_materials

5042:
5043: lStmtNum := 360;
5044: select common_bill_sequence_id
5045: into l_from_sequence_id
5046: from bom_bill_of_materials
5047: where assembly_item_id = pModelId
5048: and organization_id = pOrgId
5049: and alternate_bom_designator is NULL;
5050:

Line 5053: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',

5049: and alternate_bom_designator is NULL;
5050:
5051: lStmtNum := 370;
5052: fnd_attached_documents2_pkg.copy_attachments(
5053: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',
5054: X_from_pk1_value => l_from_sequence_id,
5055: X_from_pk2_value => '',
5056: X_from_pk3_value => '',
5057: X_from_pk4_value => '',

Line 5059: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',

5055: X_from_pk2_value => '',
5056: X_from_pk3_value => '',
5057: X_from_pk4_value => '',
5058: X_from_pk5_value => '',
5059: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',
5060: X_to_pk1_value => lConfigBillId,
5061: X_to_pk2_value => '',
5062: X_to_pk3_value => '',
5063: X_to_pk4_value => '',

Line 5626: from bom_bill_of_materials

5622: BEGIN
5623:
5624: select common_bill_sequence_id
5625: into p_bill_seq_id
5626: from bom_bill_of_materials
5627: where assembly_item_id = v_update_item_num.component_item_id
5628: and organization_id = p_org_id
5629: and alternate_bom_designator is null;
5630:

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

5655:
5656: FUNCTION inherit_op_seq_ml(
5657: pLineId in oe_order_lines.line_id%TYPE := NULL,
5658: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
5659: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
5660: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
5661: xErrorMessage out NOCOPY VARCHAR2,
5662: xMessageName out NOCOPY VARCHAR2)
5663: RETURN INTEGER IS

Line 5718: bom_bill_of_materials bbm,

5714: from bom_cto_order_lines_upg bcol1, -- COMPONENT
5715: bom_cto_order_lines_upg bcol2, -- MODEL
5716: mtl_system_items si1,
5717: mtl_system_items si2,
5718: bom_bill_of_materials bbm,
5719: bom_inventory_components bic, -- Components
5720: bom_inventory_components bic1, -- Parent
5721: bom_explosion_temp bet
5722: where bcol1.parent_ato_line_id = xLineId

Line 5930: from bom_bill_of_materials bbm

5926: mtl_system_items msi_child,
5927: mtl_system_items msi_parent
5928: where ic1.bill_sequence_id = (
5929: select common_bill_sequence_id
5930: from bom_bill_of_materials bbm
5931: where organization_id = pOrgId
5932: and alternate_bom_designator is null
5933: and assembly_item_id =(
5934: select distinct assembly_item_id

Line 5935: from bom_bill_of_materials bbm1,

5931: where organization_id = pOrgId
5932: and alternate_bom_designator is null
5933: and assembly_item_id =(
5934: select distinct assembly_item_id
5935: from bom_bill_of_materials bbm1,
5936: bom_inventory_components bic1
5937: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
5938: and component_sequence_id = bcol1.component_sequence_id
5939: and bbm1.assembly_item_id = bcol3.inventory_item_id ))

Line 6124: bom_bill_of_materials bbm,

6120: sysdate ),
6121: nvl(bic.disable_date,g_futuredate) -- 3222932
6122: , nvl(bic.basis_type,1) /* LBM project */
6123: from bom_cto_order_lines_upg bcol,
6124: bom_bill_of_materials bbm,
6125: bom_inventory_components bic
6126: where bcol.line_id = pLineId
6127: and bcol.ordered_quantity <> 0
6128: -- bugfix 2389283 and instr(bcol.component_code,'-',1,1) = 0 /* To identify Top Model */

Line 6611: from bom_bill_of_materials

6607: WriteToLog('Check_bom:Before check_bom sql::xBillId:: '||to_char(xBillId ), 5);
6608:
6609: select bill_sequence_id
6610: into xBillId
6611: from bom_bill_of_materials
6612: where assembly_item_id = pItemId
6613: and organization_id = pOrgId
6614: and alternate_bom_designator is null;
6615: