DBA Data[Home] [Help]

APPS.BOMPLDCB dependencies on BOM_OPERATION_SEQUENCES_S

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