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.BOMPLDCB dependencies on BOM_BILL_OF_MATERIALS

Line 336: BOM_BILL_OF_MATERIALS b,

332: m.demand_source_type,
333: m.demand_source_header_id,
334: m.set_id
335: from
336: BOM_BILL_OF_MATERIALS b,
337: MTL_SYSTEM_ITEMS_INTERFACE m
338: where m.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
339: and m.copy_item_id = b.assembly_item_id
340: and m.organization_id = b.organization_id

Line 585: from bom_bill_of_materials bbm /* bill for it in Mfg org.We find equivalent */

581: select component_sequence_id /* in d1 points to components in validation */
582: from bom_inventory_components bic /* so,we need to map these to Mfg org. For */
583: where bill_sequence_id = ( /* this we find the assembly to which */
584: select common_bill_sequence_id /* d1.component_seq_id belongs and then find */
585: from bom_bill_of_materials bbm /* bill for it in Mfg org.We find equivalent */
586: where organization_id = d1.organization_id /* compnent in this bill by joining */
587: and alternate_bom_designator is null /* on component_item_id. Each component*/
588: and assembly_item_id =( /*is assumed to be used at one operation only */
589: select distinct assembly_item_id /* Operation_Seq_num must be same in bills in */

Line 590: from bom_bill_of_materials bbm1, /* all organizations for that assembly */

586: where organization_id = d1.organization_id /* compnent in this bill by joining */
587: and alternate_bom_designator is null /* on component_item_id. Each component*/
588: and assembly_item_id =( /*is assumed to be used at one operation only */
589: select distinct assembly_item_id /* Operation_Seq_num must be same in bills in */
590: from bom_bill_of_materials bbm1, /* all organizations for that assembly */
591: bom_inventory_components bic1
592: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
593: and component_sequence_id = d1.component_sequence_id
594: and bbm1.assembly_item_id = d3.inventory_item_id))

Line 754: bom_bill_of_materials b,

750: bom_bill_of_mtls_interface b1,
751: mtl_demand d2, /* Model-Parent */
752: mtl_demand d1, /* Standard Mandatory comp */
753: mtl_system_items si1,
754: bom_bill_of_materials b,
755: bom_inventory_components ic1
756: where d1.organization_id = si1.organization_id
757: and d1.inventory_item_id = si1.inventory_item_id
758: and d1.config_status = 20

Line 929: from bom_bill_of_materials bbm

925: select component_sequence_id
926: from bom_inventory_components bic
927: where bill_sequence_id = (
928: select common_bill_sequence_id
929: from bom_bill_of_materials bbm
930: where organization_id = d1.organization_id
931: and alternate_bom_designator is null
932: and assembly_item_id =(
933: select distinct assembly_item_id

Line 934: from bom_bill_of_materials bbm1,

930: where organization_id = d1.organization_id
931: and alternate_bom_designator is null
932: and assembly_item_id =(
933: select distinct assembly_item_id
934: from bom_bill_of_materials bbm1,
935: bom_inventory_components bic1
936: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
937: and component_sequence_id = d1.component_sequence_id
938: and (bbm1.assembly_item_id = d3.inventory_item_id

Line 1696: bom_bill_of_materials b1,

1692: mtl_demand d1, /* components */
1693: mtl_demand d2, /* parents */
1694: mtl_demand d3, /* Model estd release date */
1695: bom_inventory_components ic1,
1696: bom_bill_of_materials b1,
1697: bom_operational_routings or1,
1698: bom_operation_sequences os1
1699: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1700: and d1.rto_model_source_line = b.demand_source_line

Line 1719: from bom_bill_of_materials bbm

1715: select component_sequence_id
1716: from bom_inventory_components bic
1717: where bill_sequence_id = (
1718: select common_bill_sequence_id
1719: from bom_bill_of_materials bbm
1720: where organization_id = d1.organization_id
1721: and alternate_bom_designator is null
1722: and assembly_item_id =(
1723: select distinct assembly_item_id

Line 1724: from bom_bill_of_materials bbm1,

1720: where organization_id = d1.organization_id
1721: and alternate_bom_designator is null
1722: and assembly_item_id =(
1723: select distinct assembly_item_id
1724: from bom_bill_of_materials bbm1,
1725: bom_inventory_components bic1
1726: where bbm1.common_bill_sequence_id = bic1.bill_sequence_id
1727: and component_sequence_id = d1.component_sequence_id
1728: and bbm1.assembly_item_id = d2.inventory_item_id))

Line 1875: bom_bill_of_materials b1,

1871: bom_operation_sequences os1,
1872: bom_operational_routings or1,
1873: mtl_system_items si2,
1874: bom_inventory_components ic1,
1875: bom_bill_of_materials b1,
1876: mtl_system_items si1,
1877: mtl_demand d2, /* Model if option class */
1878: mtl_demand d1, /* Model or option class */
1879: bom_op_routings_interface b