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 819: from bom_bill_of_materials bbm -- bill for it in Mfg org.We find equivalent

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

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

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

Line 1063: bom_bill_of_materials b,

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

Line 2227: bom_bill_of_materials bom

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

Line 2764: from bom_bill_of_materials

2760: -- get bill_sequence_id of top model
2761: --
2762: select common_bill_sequence_id
2763: into p_bill_seq_id
2764: from bom_bill_of_materials
2765: where assembly_item_id =
2766: (select component_item_id
2767: from bom_inventory_comps_interface
2768: where bill_sequence_id = pConfigBillId and parent_bill_seq_id = 0) -- Sushant Fixed bug #3374548

Line 2793: from bom_bill_of_materials where bill_sequence_id = pConfigBillId ;

2789:
2790: begin
2791: select organization_id, assembly_item_id , creation_date
2792: into v_bom_organization_id, v_bom_assembly_item_id, v_bom_creation_date
2793: from bom_bill_of_materials where bill_sequence_id = pConfigBillId ;
2794:
2795: exception
2796: when others then
2797:

Line 2811: Load BOM_bill_of_materials

2807: oe_debug_pub.add('create_bom_data_ml: ' || 'assid ' || v_bom_assembly_item_id ,2);
2808: oe_debug_pub.add('create_bom_data_ml: ' || 'date ' || v_bom_creation_date ,2);
2809: /*-------------------------------------------+
2810:
2811: Load BOM_bill_of_materials
2812: +-------------------------------------------*/
2813: IF PG_DEBUG <> 0 THEN
2814: oe_debug_pub.add('create_bom_data_ml: ' || 'Before first insert into bill_of_materials.' ,2);
2815: oe_debug_pub.add('create_bom_data_ml: ' || 'Org: ' ||to_char(pOrgId), 2);

Line 2863: xTableName := 'BOM_BILL_OF_MATERIALS';

2859: -- PK2_VALUE should be organization id
2860: -- So far these two columns are populated thru database trigger
2861: -- bom is planning on droping this trigger in R12, hence we need
2862: lStmtNum := 145;
2863: xTableName := 'BOM_BILL_OF_MATERIALS';
2864: insert into BOM_BILL_OF_MATERIALS(
2865: assembly_item_id,
2866: organization_id,
2867: alternate_bom_designator,

Line 2864: insert into BOM_BILL_OF_MATERIALS(

2860: -- So far these two columns are populated thru database trigger
2861: -- bom is planning on droping this trigger in R12, hence we need
2862: lStmtNum := 145;
2863: xTableName := 'BOM_BILL_OF_MATERIALS';
2864: insert into BOM_BILL_OF_MATERIALS(
2865: assembly_item_id,
2866: organization_id,
2867: alternate_bom_designator,
2868: last_update_date,

Line 2947: from bom_bill_of_materials b

2943: g_structure_type_id, -- bugfix 4271269 structure_type_id
2944: 1, -- bugfix 4271269 effectivity_control
2945: pconfigid,
2946: porgid
2947: from bom_bill_of_materials b
2948: where b.assembly_item_id = pModelId
2949: and b.organization_id = pOrgId
2950: and b.alternate_bom_designator is NULL;
2951:

Line 3308: bom_bill_of_materials b

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

Line 3348: bom_bill_of_materials bom

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

Line 3590: bom_bill_of_materials bi,

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

Line 3620: bom_bill_of_materials bi,

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

Line 3678: from bom_bill_of_materials

3674:
3675: lStmtNum := 360;
3676: select common_bill_sequence_id
3677: into l_from_sequence_id
3678: from bom_bill_of_materials
3679: where assembly_item_id = pModelId
3680: and organization_id = pOrgId
3681: and alternate_bom_designator is NULL;
3682:

Line 3685: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',

3681: and alternate_bom_designator is NULL;
3682:
3683: lStmtNum := 370;
3684: fnd_attached_documents2_pkg.copy_attachments(
3685: X_from_entity_name => 'BOM_BILL_OF_MATERIALS',
3686: X_from_pk1_value => l_from_sequence_id,
3687: X_from_pk2_value => '',
3688: X_from_pk3_value => '',
3689: X_from_pk4_value => '',

Line 3691: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',

3687: X_from_pk2_value => '',
3688: X_from_pk3_value => '',
3689: X_from_pk4_value => '',
3690: X_from_pk5_value => '',
3691: X_to_entity_name => 'BOM_BILL_OF_MATERIALS',
3692: X_to_pk1_value => pConfigBillId,
3693: X_to_pk2_value => '',
3694: X_to_pk3_value => '',
3695: X_to_pk4_value => '',

Line 3823: from bom_bill_of_materials

3819: BEGIN
3820:
3821: select common_bill_sequence_id
3822: into p_bill_seq_id
3823: from bom_bill_of_materials
3824: where assembly_item_id = v_update_item_num.component_item_id
3825: and organization_id = p_org_id
3826: and alternate_bom_designator is null;
3827:

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

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

Line 3913: bom_bill_of_materials bbm,

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

Line 4160: from bom_bill_of_materials bbm

4156: mtl_system_items msi_child,
4157: mtl_system_items msi_parent
4158: where ic1.bill_sequence_id = (
4159: select common_bill_sequence_id
4160: from bom_bill_of_materials bbm
4161: where organization_id = pOrgId
4162: and alternate_bom_designator is null
4163: and assembly_item_id =(
4164: select distinct assembly_item_id

Line 4165: from bom_bill_of_materials bbm1,

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

Line 4390: bom_bill_of_materials bbm,

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

Line 4904: from bom_bill_of_materials

4900:
4901:
4902: select bill_sequence_id
4903: into xBillId
4904: from bom_bill_of_materials
4905: where assembly_item_id = pItemId
4906: and organization_id = pOrgId
4907: and alternate_bom_designator is null;
4908: