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.WIP_MOVPROC_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 7487: SET transaction_temp_id = mtl_material_transactions_s.nextval

7483: --(p_txn_type = WIP_CONSTANTS.MOVE_TXN AND
7484: -- l_mandatory_scrap_flag = WIP_CONSTANTS.YES))) THEN
7485:
7486: UPDATE mtl_material_transactions_temp
7487: SET transaction_temp_id = mtl_material_transactions_s.nextval
7488: WHERE transaction_header_id = p_mtl_header_id
7489: AND transaction_temp_id IS NULL
7490: AND transaction_action_id = p_txn_action_id
7491: AND transaction_type_id = p_txn_type_id

Line 7664: SET mmtt1.transaction_temp_id = mtl_material_transactions_s.nextval

7660:
7661: -- Modified Sql For Performance Bug 13798118. Used Exists instead of In Clause.
7662:
7663: UPDATE mtl_material_transactions_temp mmtt1
7664: SET mmtt1.transaction_temp_id = mtl_material_transactions_s.nextval
7665: WHERE exists ( SELECT 1
7666: FROM wip_move_txn_interface wmti,
7667: mtl_parameters mp,
7668: mtl_material_transactions_temp mmtt2

Line 8224: SELECT mtl_material_transactions_s.nextval

8220:
8221: /* Generate a mtl txn header id IF one has not already been generated */
8222: IF(p_gib.mtl_header_id IS NULL OR
8223: p_gib.mtl_header_id = -1) THEN
8224: SELECT mtl_material_transactions_s.nextval
8225: INTO p_gib.mtl_header_id
8226: FROM DUAL;
8227: END IF;
8228:

Line 8297: mtl_material_transactions_s.nextval, -- transaction_temp_id

8293: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
8294: DECODE(p_gib.request_id,
8295: -1,NULL,SYSDATE), -- program_update_date
8296: p_gib.mtl_header_id, -- transaction_header_id
8297: mtl_material_transactions_s.nextval, -- transaction_temp_id
8298: wmti.source_code,
8299: wmti.source_line_id,
8300: l_transaction_mode, -- transaction_mode
8301: wmti.primary_item_id, -- inventory_item_id

Line 8422: SELECT mtl_material_transactions_s.nextval, -- material_alloc_id

8418: posting_flag,
8419: transaction_batch_id,
8420: transaction_batch_seq
8421: )
8422: SELECT mtl_material_transactions_s.nextval, -- material_alloc_id
8423: wmti.last_updated_by, -- last_updated_by --Fix for bug 5195072
8424: SYSDATE, -- last_update_date
8425: DECODE(p_gib.login_id,-1,NULL,p_gib.login_id),
8426: wmti.created_by, -- created_by --Fix for bug 5195072

Line 8434: mtl_material_transactions_s.nextval, -- transaction_temp_id

8430: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
8431: DECODE(p_gib.request_id,
8432: -1,NULL,SYSDATE), -- program_update_date
8433: p_gib.mtl_header_id, -- transaction_header_id
8434: mtl_material_transactions_s.nextval, -- transaction_temp_id
8435: wmti.source_code,
8436: wmti.source_line_id,
8437: l_transaction_mode, -- transaction_mode
8438: wmti.primary_item_id, -- inventory_item_id

Line 8721: SELECT mtl_material_transactions_s.nextval

8717:
8718: /* Generate a mtl txn header id IF one has not already been generated */
8719: IF(p_gib.mtl_header_id IS NULL OR
8720: p_gib.mtl_header_id = -1) THEN
8721: SELECT mtl_material_transactions_s.nextval
8722: INTO p_gib.mtl_header_id
8723: FROM DUAL;
8724: END IF;
8725:

Line 8730: SELECT mtl_material_transactions_s.nextval

8726: IF(p_gib.assy_header_id IS NULL OR
8727: p_gib.assy_header_id = -1) THEN
8728: -- Generate new header ID for assembly records because we want inventory
8729: -- to process assembly records, but not component records.
8730: SELECT mtl_material_transactions_s.nextval
8731: INTO p_gib.assy_header_id
8732: FROM DUAL;
8733: END IF;
8734:

Line 8815: select NVL(p_gib.move_profile.cmp_txn_id,mtl_material_transactions_s.nextval), mtl_material_transactions_s.nextval, t.*

8811: qa_collection_id,
8812: FINAL_COMPLETION_FLAG -- FP bug 7315664 for bug 7281164
8813: )/*7314913: Inserting into MTI based on order of transaction_date*/
8814: /*Sequence and order by cannot exist in the same level of select, thus re-writing the select statement as sub-query*/
8815: select NVL(p_gib.move_profile.cmp_txn_id,mtl_material_transactions_s.nextval), mtl_material_transactions_s.nextval, t.*
8816: from
8817: (SELECT wmti.last_updated_by last_updated_by, -- last_update_by --Fix for bug 5195072
8818: SYSDATE last_update_date, -- last_update_date
8819: DECODE(p_gib.login_id, -1, NULL, p_gib.login_id) login_id,

Line 8829: -- mtl_material_transactions_s.nextval),

8825: DECODE(p_gib.request_id, -1, NULL, SYSDATE) program_update_date,
8826: p_gib.assy_header_id transaction_header_id,
8827: 'WIP Completion' source_code,
8828: -- NVL(p_gib.move_profile.cmp_txn_id,-- completion_transaction_id
8829: -- mtl_material_transactions_s.nextval),
8830: wmti.transaction_id move_transaction_id,
8831: wmti.primary_item_id inventory_item_id,
8832: wdj.completion_subinventory subinventory_code,
8833: wdj.completion_locator_id locator_id,

Line 8876: -- mtl_material_transactions_s.nextval, -- transaction_interface_id

8872: wmti.wip_entity_id source_header_id,
8873: wop.operation_seq_num source_line_id,
8874: p_gib.assy_header_id transaction_batch_id,
8875: WIP_CONSTANTS.ASSY_BATCH_SEQ transaction_batch_seq,
8876: -- mtl_material_transactions_s.nextval, -- transaction_interface_id
8877: -- populate this value for EZ completion/return because
8878: -- material processor need this value to enable quality
8879: wmti.qa_collection_id qa_collection_id,
8880: Decode(wmti.entity_type,5,'Y') -- FP bug 7315664 for bug 7281164

Line 8962: select NVL(p_gib.move_profile.cmp_txn_id,mtl_material_transactions_s.nextval), mtl_material_transactions_s.nextval, t.*

8958: -- processor need this value to enable quality
8959: qa_collection_id
8960: )/*7314913: Inserting into MTI based on order of transaction_date*/
8961: /*Sequence and order by cannot exist in the same level of select, thus re-writing the select statement as sub-query*/
8962: select NVL(p_gib.move_profile.cmp_txn_id,mtl_material_transactions_s.nextval), mtl_material_transactions_s.nextval, t.*
8963: from
8964: (SELECT wmti.last_updated_by last_update_by, --Fix for bug 5195072
8965: SYSDATE last_update_date,
8966: DECODE(p_gib.login_id, -1, NULL, p_gib.login_id) login_id,

Line 8976: -- mtl_material_transactions_s.nextval),

8972: DECODE(p_gib.request_id, -1, NULL, SYSDATE) program_update_date,
8973: p_gib.assy_header_id transaction_header_id,
8974: 'WIP Completion' source_code,
8975: -- NVL(p_gib.move_profile.cmp_txn_id, -- completion_transaction_id
8976: -- mtl_material_transactions_s.nextval),
8977: wmti.transaction_id move_transaction_id,
8978: wmti.primary_item_id inventory_item_id,
8979: wri.completion_subinventory subinventory_code,
8980: wri.completion_locator_id locator_id,

Line 9017: -- mtl_material_transactions_s.nextval, -- transaction_interface_id

9013: wmti.wip_entity_id source_header_id,
9014: wop.operation_seq_num source_line_id,
9015: p_gib.assy_header_id transaction_batch_id,
9016: WIP_CONSTANTS.ASSY_BATCH_SEQ transaction_batch_seq,
9017: -- mtl_material_transactions_s.nextval, -- transaction_interface_id
9018: -- populate this value for EZ completion/return because
9019: -- material processor need this value to enable quality
9020: wmti.qa_collection_id qa_collection_id
9021: FROM wip_move_txn_interface wmti,

Line 9128: WIP_CONSTANTS.FULL_SN, mtl_material_transactions_s.nextval,

9124: mti.last_update_date,
9125: mti.last_updated_by,
9126: mti.last_update_login,
9127: DECODE(msi.serial_number_control_code,
9128: WIP_CONSTANTS.FULL_SN, mtl_material_transactions_s.nextval,
9129: WIP_CONSTANTS.DYN_RCV_SN,mtl_material_transactions_s.nextval,
9130: NULL),
9131: 1, -- Bug 13734082 ,FP Bug for Populating orignation type as 'Production'
9132: mti.transaction_date

Line 9129: WIP_CONSTANTS.DYN_RCV_SN,mtl_material_transactions_s.nextval,

9125: mti.last_updated_by,
9126: mti.last_update_login,
9127: DECODE(msi.serial_number_control_code,
9128: WIP_CONSTANTS.FULL_SN, mtl_material_transactions_s.nextval,
9129: WIP_CONSTANTS.DYN_RCV_SN,mtl_material_transactions_s.nextval,
9130: NULL),
9131: 1, -- Bug 13734082 ,FP Bug for Populating orignation type as 'Production'
9132: mti.transaction_date
9133: FROM mtl_transactions_interface mti,

Line 10445: SELECT mtl_material_transactions_s.nextval

10441: IF(l_gib.bf_mode = WIP_CONSTANTS.ONLINE) THEN
10442: IF(p_do_backflush = fnd_api.g_true) THEN
10443: IF(l_gib.mtl_header_id IS NULL OR
10444: l_gib.mtl_header_id = -1) THEN
10445: SELECT mtl_material_transactions_s.nextval
10446: INTO l_gib.mtl_header_id
10447: FROM DUAL;
10448: END IF;
10449: