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_INVENTORY_COMPONENTS

Line 324: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

320: NULL, /* attribute13 */
321: NULL, /* attribute14 */
322: NULL, /* attribute15 */
323: b.assembly_type, /* assembly_ type */
324: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
325: BOM_INVENTORY_COMPONENTS_S.CURRVAL,
326: NULL, /* request id */
327: NULL, /* program_application_id */
328: NULL, /* program id */

Line 325: BOM_INVENTORY_COMPONENTS_S.CURRVAL,

321: NULL, /* attribute14 */
322: NULL, /* attribute15 */
323: b.assembly_type, /* assembly_ type */
324: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
325: BOM_INVENTORY_COMPONENTS_S.CURRVAL,
326: NULL, /* request id */
327: NULL, /* program_application_id */
328: NULL, /* program id */
329: NULL, /* program date */

Line 411: from bom_inventory_components bic1, /child /

407: (select distinct
408: decode(NVL(bic1.operation_seq_num,1),
409: 1,NVL(d2.operation_seq_num,bic2.operation_seq_num),
410: bic1.operation_seq_num)
411: from bom_inventory_components bic1, /*child */
412: bom_inventory_components bic2, /*parent */
413: mtl_demand d2
414: where bic1.component_sequence_id=d0.component_sequence_id
415: and bic2.component_sequence_id=d0.parent_component_seq_id

Line 412: bom_inventory_components bic2, /parent /

408: decode(NVL(bic1.operation_seq_num,1),
409: 1,NVL(d2.operation_seq_num,bic2.operation_seq_num),
410: bic1.operation_seq_num)
411: from bom_inventory_components bic1, /*child */
412: bom_inventory_components bic2, /*parent */
413: mtl_demand d2
414: where bic1.component_sequence_id=d0.component_sequence_id
415: and bic2.component_sequence_id=d0.parent_component_seq_id
416: and d0.parent_component_seq_id=d2.component_sequence_id

Line 559: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

555: NULL, /* low_quantity */
556: NULL, /* high_quantity */
557: NULL, /* acd_type */
558: NULL, /*old_component_sequence_id */
559: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
560: /* component sequence id */
561: b.bill_sequence_id, /* bill sequence id */
562: NULL, /* request_id */
563: NULL, /* program_application_id */

Line 575: bom_inventory_components ic1,

571: seq id for later use */
572: ic1.supply_subinventory,
573: ic1.supply_locator_id
574: from
575: bom_inventory_components ic1,
576: mtl_demand d1, /*Option */
577: mtl_demand d2, /* Parent-Model */
578: mtl_demand d3, /* parent-Component */
579: bom_bill_of_mtls_interface b

Line 582: from bom_inventory_components bic /* so,we need to map these to Mfg org. For */

578: mtl_demand d3, /* parent-Component */
579: bom_bill_of_mtls_interface b
580: where ic1.component_sequence_id =( /* Refer bug 625484. component_sequence_id */
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 */

Line 591: bom_inventory_components bic1

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))
595: and bic.component_item_id = d1.inventory_item_id

Line 734: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

730: NULL, /* low_quantity */
731: NULL, /* high_quantity */
732: NULL, /* acd_type */
733: NULL, /* old_component_sequence_id */
734: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
735: /* component sequence id */
736: b1.bill_sequence_id, /* bill sequence id */
737: NULL, /* request_id */
738: NULL, /* program_application_id */

Line 755: bom_inventory_components ic1

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
759: and si1.bom_item_type in (1,2)

Line 903: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

899: NULL, /* low_quantity */
900: NULL, /* high_quantity */
901: NULL, /* acd_type */
902: NULL, /* old_component_sequence_id */
903: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
904: /* component sequence id */
905: b.bill_sequence_id, /* bill sequence id */
906: NULL, /* request_id */
907: NULL, /* program_application_id */

Line 923: bom_inventory_components ic1

919: bom_bill_of_mtls_interface b,
920: mtl_demand d2, /* Model */
921: mtl_demand d1, /* Option Classes */
922: mtl_demand d3, /* parent component */
923: bom_inventory_components ic1
924: where ic1.component_sequence_id =( /* See 625484 releated comments in stmt 60 */
925: select component_sequence_id
926: from bom_inventory_components bic
927: where bill_sequence_id = (

Line 926: from bom_inventory_components bic

922: mtl_demand d3, /* parent component */
923: bom_inventory_components ic1
924: where ic1.component_sequence_id =( /* See 625484 releated comments in stmt 60 */
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

Line 935: bom_inventory_components bic1

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
939: OR bbm1.assembly_item_id = d2.inventory_item_id)))

Line 1073: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

1069: NULL, /* low_quantity */
1070: NULL, /* high_quantity */
1071: NULL, /* acd_type */
1072: NULL, /* old_component_sequence_id */
1073: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
1074: /* component sequence id */
1075: b.bill_sequence_id, /* bill sequence id */
1076: NULL, /* request_id */
1077: NULL, /* program_application_id */

Line 1695: bom_inventory_components ic1,

1691: bom_op_routings_interface b,
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')))

Line 1716: from bom_inventory_components bic

1712: and d3.demand_source_line = d1.rto_model_source_line
1713: and d3.primary_uom_quantity <> 0
1714: and ic1.component_sequence_id = ( /* See 625484 releated comments in stmt 60 */
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

Line 1725: bom_inventory_components bic1

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))
1729: and bic.component_item_id = d1.inventory_item_id

Line 1874: bom_inventory_components ic1,

1870: from
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 */

Line 2347: bom_inventory_components bc,

2343: NVL(max(v.element_value),i.element_value)
2344: from
2345: bom_bill_of_mtls_interface bi,
2346: bom_inventory_comps_interface bci,
2347: bom_inventory_components bc,
2348: bom_dependent_desc_elements be,
2349: mtl_descr_element_values v
2350: where bi.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
2351: and bi.assembly_item_id = i.inventory_item_id