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_OPERATION_SEQUENCES

Line 1324: BOM_OPERATION_SEQUENCES_S.NEXTVAL,

1320: TOTAL_TIME_USER,
1321: NET_PLANNING_PERCENT
1322: )
1323: select
1324: BOM_OPERATION_SEQUENCES_S.NEXTVAL,
1325: b1.routing_sequence_id, /* routing_sequence_id */
1326: os1.operation_seq_num,
1327: SYSDATE, /* last update date */
1328: 1, /* last updated by */

Line 1385: bom_operation_sequences os1

1381: mtl_demand d2,/* Model for est. release date */
1382: mtl_demand d1,
1383: mtl_system_items si1,
1384: bom_operational_routings or1,
1385: bom_operation_sequences os1
1386: where b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1387: and d1.rto_model_source_line = b1.demand_source_line
1388: and d1.config_status = 20
1389: and d1.primary_uom_quantity <> 0

Line 1479: BOM_OPERATION_SEQUENCES_S.NEXTVAL,

1475: TOTAL_TIME_USER,
1476: NET_PLANNING_PERCENT
1477: )
1478: select
1479: BOM_OPERATION_SEQUENCES_S.NEXTVAL,
1480: b1.routing_sequence_id, /* routing_sequence_id */
1481: os1.operation_seq_num,
1482: SYSDATE, /* last update date */
1483: 1, /* last updated by */

Line 1540: bom_operation_sequences os1

1536: mtl_demand d2,/* Model for est. release date */
1537: mtl_demand d1,
1538: mtl_system_items si1,
1539: bom_operational_routings or1,
1540: bom_operation_sequences os1
1541: where b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1542: and d1.rto_model_source_line = b1.demand_source_line
1543: and d1.config_status = 20
1544: and d1.primary_uom_quantity <> 0

Line 1635: BOM_OPERATION_SEQUENCES_S.NEXTVAL,

1631: TOTAL_TIME_USER,
1632: NET_PLANNING_PERCENT
1633: )
1634: select /*+ ORDERED */
1635: BOM_OPERATION_SEQUENCES_S.NEXTVAL,
1636: b.routing_sequence_id, /* routing_sequence_id */
1637: os1.operation_seq_num,
1638: SYSDATE, /* last update date */
1639: 1, /* last updated by */

Line 1698: bom_operation_sequences os1

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
1701: and d1.demand_type in (2,3) /* option class,option item */
1702: and d1.config_status = 20

Line 1814: BOM_OPERATION_SEQUENCES_S.NEXTVAL,

1810: TOTAL_TIME_USER,
1811: NET_PLANNING_PERCENT
1812: )
1813: select
1814: BOM_OPERATION_SEQUENCES_S.NEXTVAL,
1815: /* operation_sequence_id */
1816: b.routing_sequence_id, /* routing_sequence_id */
1817: os1.operation_seq_num,
1818: SYSDATE, /* last update date */

Line 1871: bom_operation_sequences os1,

1867: machine_time_user,
1868: total_time_user,
1869: Net_planning_percent
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,

Line 2016: bom_operation_sequences s,

2012: from
2013: mtl_demand md,
2014: mtl_system_items ms,
2015: bom_operational_routings r,
2016: bom_operation_sequences s,
2017: bom_op_routings_interface ri
2018: where ri.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
2019: and ri.routing_sequence_id = si.routing_sequence_id
2020: and md.rto_model_source_line = ri.demand_source_line