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_FLOW_UTILITIES dependencies on MTL_TRANSACTIONS_INTERFACE

Line 67: from Mtl_transactions_interface

63: SUBSTITUTION_ITEM_ID,
64: SUBSTITUTION_TYPE_ID,
65: OPERATION_SEQ_NUM,
66: FLOW_SCHEDULE
67: from Mtl_transactions_interface
68: where parent_id = p_parent_id
69: and substitution_type_id is not null
70: and process_flag = 2
71: and organization_id = p_organization_Id ;

Line 95: from mtl_transactions_interface

91: end ;
92:
93: select operation_seq_num
94: into x_parent_op_seq
95: from mtl_transactions_interface
96: where transaction_interface_id = p_parent_id;
97:
98: begin
99: SELECT mti.routing_revision_date, bor.routing_sequence_id -- CFM Scrap

Line 101: FROM mtl_transactions_interface mti, bom_operational_routings bor

97:
98: begin
99: SELECT mti.routing_revision_date, bor.routing_sequence_id -- CFM Scrap
100: INTO x_rout_rev_date, x_rout_seq_id
101: FROM mtl_transactions_interface mti, bom_operational_routings bor
102: WHERE mti.transaction_interface_id = p_parent_id
103: AND mti.inventory_item_id = bor.assembly_item_id(+)
104: AND mti.organization_id = bor.organization_id(+)
105: AND Nvl(mti.alternate_routing_designator,'@@@@') = Nvl(bor.alternate_routing_designator,'@@@@');

Line 410: mtl_transactions_interface mti

406: be open */
407:
408: select 1 into x_success
409: from wip_flow_schedules wfs,
410: mtl_transactions_interface mti
411: where wfs.wip_entity_id = p_txn_src_id
412: and wfs.organization_id = p_organization_id
413: and trunc(wfs.scheduled_completion_date,WIP_CONSTANTS.DATE_FMT) =
414: trunc(mti.transaction_date,WIP_CONSTANTS.DATE_FMT)

Line 496: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

492: -- This is failure
493:
494: x_message := fnd_message.get ;
495:
496: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
497: SET LAST_UPDATE_DATE = SYSDATE,
498: PROGRAM_UPDATE_DATE = SYSDATE,
499: PROCESS_FLAG = 3,
500: LOCK_FLAG = 2,

Line 515: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

511: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');
512: fnd_message.set_token('ENTITY1', p_schedule_number);
513: x_message := fnd_message.get ;
514:
515: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
516: SET LAST_UPDATE_DATE = SYSDATE,
517: PROGRAM_UPDATE_DATE = SYSDATE,
518: PROCESS_FLAG = 3,
519: LOCK_FLAG = 2,

Line 537: UPDATE mtl_transactions_interface MTI

533: p_err_mesg in out nocopy varchar2) return number is
534: begin
535:
536:
537: UPDATE mtl_transactions_interface MTI
538: SET LAST_UPDATE_DATE = SYSDATE,
539: PROGRAM_UPDATE_DATE = SYSDATE,
540: REVISION =
541: (SELECT NVL(mti.revision, MAX(mir.revision))

Line 695: FROM mtl_transactions_interface

691: scheduled_flag,
692: wip_entity_type,
693: end_item_unit_number,
694: rowid
695: FROM mtl_transactions_interface
696: WHERE transaction_header_id = header_id
697: AND TRANSACTION_SOURCE_TYPE_ID = 5
698: AND FLOW_SCHEDULE = 'Y'
699: AND transaction_action_id in (31, 32, 30) -- CFM Scrap

Line 784: Update Mtl_Transactions_Interface

780: p_txn_int_id => flow_rec.transaction_interface_id,
781: p_txn_action_id => flow_rec.transaction_action_id -- CFM Scrap
782: ) = 1) then
783:
784: Update Mtl_Transactions_Interface
785: Set
786: transaction_source_id = flow_rec.transaction_source_id,
787: schedule_number = flow_rec.schedule_number,
788: source_project_id = flow_rec.source_project_id,

Line 811: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

807: fnd_message.set_token('ENTITY1',to_char(flow_rec.transaction_interface_id));
808:
809: x_message := fnd_message.get ;
810:
811: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
812: SET LAST_UPDATE_DATE = SYSDATE,
813: PROGRAM_UPDATE_DATE = SYSDATE,
814: PROCESS_FLAG = 3,
815: LOCK_FLAG = 2,

Line 864: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

860: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');
861:
862: x_message := fnd_message.get ;
863:
864: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
865: SET LAST_UPDATE_DATE = SYSDATE,
866: PROGRAM_UPDATE_DATE = SYSDATE,
867: PROCESS_FLAG = 3,
868: LOCK_FLAG = 2,

Line 933: Update Mtl_transactions_interface

929: if(x_success = 0) then
930: raise general ;
931: end if;
932:
933: Update Mtl_transactions_interface
934: set transaction_source_id = wip_entities_s.currval,
935: scheduled_flag = 2, -- No
936: schedule_number = flow_rec.schedule_number,
937: primary_quantity = flow_rec.primary_quantity

Line 971: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

967: x_message := fnd_message.get ;
968: x_sql_err_num := SQLCODE;
969: x_sql_message := substr(SQLERRM,1,240);
970:
971: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
972: SET LAST_UPDATE_DATE = SYSDATE,
973: PROGRAM_UPDATE_DATE = SYSDATE,
974: PROCESS_FLAG = 3,
975: LOCK_FLAG = 2,

Line 998: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

994: x_sql_err_num := SQLCODE;
995: x_sql_message := substr(SQLERRM,1,240);
996:
997:
998: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
999: SET LAST_UPDATE_DATE = SYSDATE,
1000: PROGRAM_UPDATE_DATE = SYSDATE,
1001: PROCESS_FLAG = 3,
1002: LOCK_FLAG = 2,

Line 1276: FROM mtl_transactions_interface

1272: -- **********************************************
1273: CURSOR Del_Flow(header_id number) is
1274: SELECT transaction_interface_id, rowid,
1275: transaction_source_id, organization_Id
1276: FROM mtl_transactions_interface
1277: WHERE transaction_header_id = header_id
1278: AND TRANSACTION_SOURCE_TYPE_ID = 5
1279: AND FLOW_SCHEDULE = 'Y'
1280: AND scheduled_flag <> 1

Line 1296: update mtl_transactions_interface

1292: delete wip_flow_schedules
1293: where wip_entity_id = del_rec.transaction_source_id
1294: and organization_id = del_rec.organization_id ;
1295:
1296: update mtl_transactions_interface
1297: set transaction_source_id = NULL
1298: where rowid = del_rec.rowid ;
1299:
1300: exception

Line 1310: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

1306: fnd_message.set_token('ENTITY1',
1307: to_char(del_rec.transaction_interface_id) );
1308: x_message := fnd_message.get ;
1309:
1310: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
1311: SET LAST_UPDATE_DATE = SYSDATE,
1312: PROGRAM_UPDATE_DATE = SYSDATE,
1313: PROCESS_FLAG = 3,
1314: LOCK_FLAG = 2,

Line 1336: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

1332: to_char(p_header_id) );
1333: x_message := fnd_message.get ;
1334:
1335:
1336: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
1337: SET LAST_UPDATE_DATE = SYSDATE,
1338: PROGRAM_UPDATE_DATE = SYSDATE,
1339: PROCESS_FLAG = 3,
1340: LOCK_FLAG = 2,

Line 1481: Update Mtl_transactions_interface

1477: select MTL_MATERIAL_TRANSACTIONS_S.nextval into x_new_txn_hdr
1478: from sys.dual ;
1479:
1480:
1481: Update Mtl_transactions_interface
1482: set TRANSACTION_HEADER_ID = x_new_txn_hdr,
1483: PROCESS_FLAG = 1,
1484: LAST_UPDATE_DATE = SYSDATE,
1485: LAST_UPDATED_BY = p_user_id,

Line 1541: Update Mtl_transactions_interface

1537: begin
1538:
1539:
1540: -- Update the header id of the original completion
1541: Update Mtl_transactions_interface
1542: set TRANSACTION_HEADER_ID = p_hdr_id
1543: where transaction_interface_id = p_interface_id ;
1544:
1545: -- Set the information for the backflushed/substitution

Line 1547: Update Mtl_transactions_interface

1543: where transaction_interface_id = p_interface_id ;
1544:
1545: -- Set the information for the backflushed/substitution
1546: -- issues
1547: Update Mtl_transactions_interface
1548: set PROCESS_FLAG = 1,
1549: LAST_UPDATE_DATE = SYSDATE,
1550: LAST_UPDATED_BY = p_user_id,
1551: LAST_UPDATE_LOGIN = p_login_id,

Line 1630: FROM MTL_TRANSACTIONS_INTERFACE MTI

1626:
1627: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
1628: WHERE TRANSACTION_INTERFACE_ID IN (
1629: SELECT MTI.TRANSACTION_INTERFACE_ID
1630: FROM MTL_TRANSACTIONS_INTERFACE MTI
1631: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
1632: AND MTI.PROCESS_FLAG = 1);
1633:
1634: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE MSNI

Line 1638: MTL_TRANSACTIONS_INTERFACE MTI

1634: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE MSNI
1635: WHERE TRANSACTION_INTERFACE_ID IN (
1636: SELECT MTLI.SERIAL_TRANSACTION_TEMP_ID
1637: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
1638: MTL_TRANSACTIONS_INTERFACE MTI
1639: WHERE MTI.TRANSACTION_INTERFACE_ID =
1640: MTLI.TRANSACTION_INTERFACE_ID
1641: AND MTI.TRANSACTION_HEADER_ID = p_header_id
1642: AND MTI.PROCESS_FLAG = 1);

Line 1647: FROM MTL_TRANSACTIONS_INTERFACE MTI

1643:
1644: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
1645: WHERE TRANSACTION_INTERFACE_ID IN (
1646: SELECT MTI.TRANSACTION_INTERFACE_ID
1647: FROM MTL_TRANSACTIONS_INTERFACE MTI
1648: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
1649: AND MTI.PROCESS_FLAG = 1);
1650:
1651: DELETE FROM MTL_TRANSACTIONS_INTERFACE

Line 1651: DELETE FROM MTL_TRANSACTIONS_INTERFACE

1647: FROM MTL_TRANSACTIONS_INTERFACE MTI
1648: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
1649: AND MTI.PROCESS_FLAG = 1);
1650:
1651: DELETE FROM MTL_TRANSACTIONS_INTERFACE
1652: WHERE TRANSACTION_HEADER_ID = p_header_id
1653: AND PROCESS_FLAG = 1;
1654:
1655: return 1;

Line 1679: from MTL_TRANSACTIONS_INTERFACE

1675: begin
1676:
1677: select ERROR_EXPLANATION
1678: into l_err_mesg
1679: from MTL_TRANSACTIONS_INTERFACE
1680: where PROCESS_FLAG = 3
1681: AND LOCK_FLAG = 2
1682: AND TRANSACTION_HEADER_ID = p_header_id
1683: AND ROWNUM <2;

Line 1716: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

1712: ) return number is
1713: l_unsched number := 0;
1714: begin
1715:
1716: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
1717: SET LAST_UPDATE_DATE = SYSDATE,
1718: LAST_UPDATED_BY = p_user_id,
1719: LAST_UPDATE_LOGIN = p_login_id,
1720: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2330: from mtl_transactions_interface mti,

2326: mti.transaction_source_name,
2327: mti.transfer_cost_group_id cost_group_id,
2328: least( 1, NVL(mti.transfer_lpn_id, 0) + NVL(mti.content_lpn_id, 0) ) containerized,
2329: mti.transaction_header_id -- bugfix 4455722
2330: from mtl_transactions_interface mti,
2331: mtl_system_items_kfv msi
2332: where mti.parent_id = txn_interface_id
2333: and nvl(mti.operation_seq_num, 1) > 0 /* not for phatom assembly */
2334: and mti.transaction_action_id in (1,27,33,34) /*wip_constants.isscomp_action, wip_constants.retcomp_action, wip_constants.issnegc_action, wip_constants.retnegc_action)*/