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.INV_DCP_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 594: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

590: l_module_name CONSTANT VARCHAR2(100) :=G_PKG_NAME || '.' || 'DUMP_MMTT';
591: i NUMBER :=0;
592: CURSOR c1(trx_hdr_id in NUMBER,trx_temp_id IN NUMBER) is
593: SELECT *
594: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
595: WHERE TRANSACTION_HEADER_ID=trx_hdr_id
596: AND TRANSACTION_TEMP_ID = trx_temp_id;
597: begin
598: IF g_debug_on = 1 THEN

Line 887: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

883: CURSOR C1 is
884: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
885: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
886: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
887: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
888: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
889: AND PROCESS_FLAG = 'Y'
890: AND ((TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
891: AND inventory_item_id <> -1

Line 916: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

912: CURSOR C2 is
913: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
914: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
915: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
916: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
917: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
918: AND PROCESS_FLAG = 'Y'
919: AND TRANSACTION_ACTION_ID in (2,5)
920: AND inventory_item_id <> -1

Line 946: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

942: CURSOR C3 is
943: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
944: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
945: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
946: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
947: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
948: AND PROCESS_FLAG = 'Y'
949: AND TRANSACTION_ACTION_ID = 3
950: AND inventory_item_id <> -1

Line 968: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

964: CURSOR c4 is
965: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
966: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
967: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
968: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
969: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
970: AND PROCESS_FLAG = 'Y'
971: AND inventory_item_id <> -1
972: AND ((TRANSACTION_ACTION_ID in (1,2,3,30,31,5)

Line 984: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

980: CURSOR C5 is
981: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
982: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
983: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
984: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
985: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
986: AND PROCESS_FLAG = 'Y'
987: AND LOCATOR_ID IS NOT NULL
988: AND transaction_action_id not in (24,30)

Line 1011: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1007: CURSOR C5_1 is
1008: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
1009: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
1010: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
1011: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1012: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
1013: AND PROCESS_FLAG = 'Y'
1014: AND LOCATOR_ID IS NULL
1015: AND inventory_item_id <> -1

Line 1031: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1027: UNION ALL
1028: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
1029: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
1030: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
1031: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1032: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
1033: AND PROCESS_FLAG = 'Y'
1034: AND LOCATOR_ID IS NOT NULL
1035: AND transaction_action_id not in (24,30)

Line 1052: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1048: CURSOR c6 is
1049: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
1050: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
1051: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
1052: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1053: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
1054: AND PROCESS_FLAG = 'Y'
1055: AND LOCATOR_ID IS NOT NULL
1056: AND transaction_action_id not in (24,30)

Line 1082: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1078: CURSOR c7 is
1079: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
1080: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
1081: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
1082: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1083: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
1084: AND PROCESS_FLAG = 'Y'
1085: AND TRANSACTION_ACTION_ID IN (2,3,5)
1086: AND TRANSFER_TO_LOCATION IS NOT NULL

Line 1102: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1098: CURSOR c8 is
1099: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
1100: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
1101: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
1102: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1103: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
1104: AND PROCESS_FLAG = 'Y'
1105: AND TRANSACTION_ACTION_ID in (2,21,3,5)
1106: AND TRANSFER_TO_LOCATION IS NOT NULL

Line 1135: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1131: CURSOR c9 is
1132: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
1133: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
1134: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
1135: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1136: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
1137: AND PROCESS_FLAG = 'Y'
1138: AND TRANSACTION_ACTION_ID NOT IN (24,33,34,30)
1139: AND inventory_item_id <> -1

Line 1165: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1161: CURSOR c10 is
1162: SELECT TRANSACTION_TEMP_ID,TRANSACTION_TYPE_ID,
1163: TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID,
1164: ORGANIZATION_ID,TRANSFER_ORGANIZATION,INVENTORY_ITEM_ID
1165: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1166: WHERE TRANSACTION_HEADER_ID = p_trx_hdr_id
1167: AND PROCESS_FLAG = 'Y'
1168: AND TRANSACTION_ACTION_ID = 3
1169: AND inventory_item_id <> -1

Line 1227: FROM MTL_MATERIAL_TRANSACTIONS_TEMP a,MTL_SERIAL_NUMBERS b,

1223: A.SUBINVENTORY_CODE,A.LOCATOR_ID,A.REVISION,A.LOT_NUMBER,
1224: A.TRANSFER_SUBINVENTORY,a.TRANSFER_TO_LOCATION,
1225: b.CURRENT_SUBINVENTORY_CODE,b.CURRENT_LOCATOR_ID,b.REVISION current_revision,
1226: b.CURRENT_STATUS,b.SERIAL_NUMBER,b.current_organization_id,d.SERIAL_NUMBER_CONTROL_CODE
1227: FROM MTL_MATERIAL_TRANSACTIONS_TEMP a,MTL_SERIAL_NUMBERS b,
1228: MTL_SERIAL_NUMBERS_TEMP c,MTL_SYSTEM_ITEMS d
1229: WHERE A.TRANSACTION_TEMP_ID = C.TRANSACTION_TEMP_ID
1230: AND LPAD(B.SERIAL_NUMBER,30) >= LPAD(C.FM_SERIAL_NUMBER,30)
1231: AND LPAD(NVL(B.SERIAL_NUMBER,'-99'),30) <= LPAD(NVL(C.TO_SERIAL_NUMBER,'-99'),30)