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_BILL_OF_MATERIALS

Line 178: | bom_bill_of_materials view.

Line 223: g_structure_type_id bom_bill_of_materials.structure_type_id%type ;

219:
220:
221: -- 4271269 populate structure_type_id in bom.
222:
223: g_structure_type_id bom_bill_of_materials.structure_type_id%type ;
224:
225:
226: PROCEDURE update_item_num(
227: p_parent_bill_seq_id IN NUMBER,

Line 821: from bom_bill_of_materials bbm -- bill for it in Mfg org.We find equivalent

817: mtl_system_items msi_parent
818: -- begin bugfix 1653881
819: where ic1.bill_sequence_id = ( -- this we find the assembly to which
820: select common_bill_sequence_id -- d1.component_seq_id belongs and then find
821: from bom_bill_of_materials bbm -- bill for it in Mfg org.We find equivalent
822: where organization_id = pOrgId -- compnent in this bill by joining
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

Line 826: from bom_bill_of_materials bbm1, -- all organizations for that assembly

822: where organization_id = pOrgId -- compnent in this bill by joining
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 ))

Line 1088: bom_bill_of_materials b,

1084: bom_cto_order_lines bcol1, -- component
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

Line 2267: bom_bill_of_materials bom

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
2271: and bic.component_item_id = xComponentItemId

Line 2824: from bom_bill_of_materials

2820: -- get bill_sequence_id of top model
2821: --
2822: select common_bill_sequence_id
2823: into p_bill_seq_id
2824: from bom_bill_of_materials
2825: where assembly_item_id =
2826: (select component_item_id
2827: from bom_inventory_comps_interface
2828: where bill_sequence_id = pConfigBillId and parent_bill_seq_id = 0) -- Sushant Fixed bug #3374548

Line 2853: from bom_bill_of_materials where bill_sequence_id = pConfigBillId ;

2849:
2850: begin
2851: select organization_id, assembly_item_id , creation_date
2852: into v_bom_organization_id, v_bom_assembly_item_id, v_bom_creation_date
2853: from bom_bill_of_materials where bill_sequence_id = pConfigBillId ;
2854:
2855: exception
2856: when others then
2857:

Line 2871: Load BOM_bill_of_materials

2867: oe_debug_pub.add('create_bom_data_ml: ' || 'assid ' || v_bom_assembly_item_id ,2);
2868: oe_debug_pub.add('create_bom_data_ml: ' || 'date ' || v_bom_creation_date ,2);
2869: /*-------------------------------------------+
2870:
2871: Load BOM_bill_of_materials
2872: +-------------------------------------------*/
2873: IF PG_DEBUG <> 0 THEN
2874: oe_debug_pub.add('create_bom_data_ml: ' || 'Before first insert into bill_of_materials.' ,2);
2875: oe_debug_pub.add('create_bom_data_ml: ' || 'Org: ' ||to_char(pOrgId), 2);

Line 2923: xTableName := 'BOM_BILL_OF_MATERIALS';

2919: -- PK2_VALUE should be organization id
2920: -- So far these two columns are populated thru database trigger
2921: -- bom is planning on droping this trigger in R12, hence we need
2922: lStmtNum := 145;
2923: xTableName := 'BOM_BILL_OF_MATERIALS';
2924: insert into BOM_BILL_OF_MATERIALS(
2925: assembly_item_id,
2926: organization_id,
2927: alternate_bom_designator,

Line 2924: insert into BOM_BILL_OF_MATERIALS(

2920: -- So far these two columns are populated thru database trigger
2921: -- bom is planning on droping this trigger in R12, hence we need
2922: lStmtNum := 145;
2923: xTableName := 'BOM_BILL_OF_MATERIALS';
2924: insert into BOM_BILL_OF_MATERIALS(
2925: assembly_item_id,
2926: organization_id,
2927: alternate_bom_designator,
2928: last_update_date,

Line 3015: from bom_bill_of_materials b

3011: g_structure_type_id, -- bugfix 4271269 structure_type_id
3012: 1, -- bugfix 4271269 effectivity_control
3013: pconfigid,
3014: porgid
3015: from bom_bill_of_materials b
3016: where b.assembly_item_id = pModelId
3017: and b.organization_id = pOrgId
3018: and b.alternate_bom_designator is NULL;
3019:

Line 3392: bom_bill_of_materials b

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
3395: and ic.bill_sequence_id = b.bill_sequence_id
3396: and r.component_sequence_id = abs(ic.model_comp_seq_id) -- previously last_update_login

Line 3432: bom_bill_of_materials bom

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
3436: and bic.component_item_id = component_item_id_arr(x1);

Line 3682: bom_bill_of_materials bi,

3678: set i.element_value =
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,

Line 3685: bom_bill_of_materials bi2, -- for model -- BUG 13693029 -- moved for pref

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
3689: and bi.organization_id = pOrgId

Line 3716: bom_bill_of_materials bi,

3712: set i.element_value =
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,

Line 3719: bom_bill_of_materials bi2, -- for model -- BUG 13693029 -- moved for pref

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
3723: and bi.organization_id = pOrgId

Line 3783: from bom_bill_of_materials

3779: --
3780: -- select common_bill_sequence_id
3781: select NVL(source_bill_sequence_id, common_bill_sequence_id)
3782: into l_from_sequence_id
3783: from bom_bill_of_materials
3784: where assembly_item_id = pModelId
3785: and organization_id = pOrgId
3786: and alternate_bom_designator is NULL;
3787:

Line 3794: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',

3790: END IF;
3791:
3792: lStmtNum := 370;
3793: fnd_attached_documents2_pkg.copy_attachments(
3794: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',
3795: X_from_pk1_value => l_from_sequence_id,
3796: X_from_pk2_value => '',
3797: X_from_pk3_value => '',
3798: X_from_pk4_value => '',

Line 3800: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',

3796: X_from_pk2_value => '',
3797: X_from_pk3_value => '',
3798: X_from_pk4_value => '',
3799: X_from_pk5_value => '',
3800: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',
3801: X_to_pk1_value => pConfigBillId,
3802: X_to_pk2_value => '',
3803: X_to_pk3_value => '',
3804: X_to_pk4_value => '',

Line 4002: from bom_bill_of_materials

3998: BEGIN
3999:
4000: select common_bill_sequence_id
4001: into p_bill_seq_id
4002: from bom_bill_of_materials
4003: where assembly_item_id = v_update_item_num.component_item_id
4004: and organization_id = p_org_id
4005: and alternate_bom_designator is null;
4006:

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

4029:
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

Line 4092: bom_bill_of_materials bbm,

4088: from bom_cto_order_lines bcol1, -- COMPONENT
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: /*-----------------------------------------------------------------------------------------------------+

Line 4343: from bom_bill_of_materials bbm

4339: mtl_system_items msi_child,
4340: mtl_system_items msi_parent
4341: where ic1.bill_sequence_id = (
4342: select common_bill_sequence_id
4343: from bom_bill_of_materials bbm
4344: where organization_id = pOrgId
4345: and alternate_bom_designator is null
4346: and assembly_item_id =(
4347: select distinct assembly_item_id

Line 4348: from bom_bill_of_materials bbm1,

4344: where organization_id = pOrgId
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 ))

Line 4578: bom_bill_of_materials bbm,

4574: sysdate ),
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 */

Line 5216: from bom_bill_of_materials

5212:
5213:
5214: select bill_sequence_id
5215: into xBillId
5216: from bom_bill_of_materials
5217: where assembly_item_id = pItemId
5218: and organization_id = pOrgId
5219: and alternate_bom_designator is null;
5220: