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.WSMPINVL dependencies on MTL_MATERIAL_TRANSACTIONS

Line 623: from mtl_material_transactions

619: lProcLocation := 160;
620: FOR txn in txns LOOP
621:
622: select count(*) into x_cnt
623: from mtl_material_transactions
624: where source_line_id=txn.transaction_id
625: and organization_id = txn.organization_id -- ADD: BUG2832025/2841055
626: and transaction_date = txn.transaction_date; -- ADD: BUG2832025/2841055
627:

Line 659: from mtl_material_transactions

655:
656: BEGIN
657:
658: select 1 into x_cnt
659: from mtl_material_transactions
660: where transaction_source_type_id = 13 --ADD : BUG 3756725
661: --and transaction_id = txn.transaction_id --removed: bug 4401205
662: and transaction_date = txn.transaction_date --ADD : bug 4919094
663: and organization_id = txn.organization_id --ADD : BUG 3756725

Line 973: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

969:
970:
971: BEGIN
972:
973: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
974: INTO X_Header_Id
975: FROM DUAL;
976:
977: return(X_Header_Id);

Line 987: return(MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL);

983: FUNCTION Get_Header_Id RETURN NUMBER IS
984:
985: BEGIN
986:
987: return(MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL);
988:
989: END Get_Header_Id;
990: */
991:

Line 1233: FROM mtl_material_transactions_temp mmtt

1229: IF x_dummy <>0 then
1230: lProcLocation := 30;
1231:
1232: SELECT 0 into x_dummy -- Fine if it satisfies this condition.
1233: FROM mtl_material_transactions_temp mmtt
1234: WHERE mmtt.organization_id = crec.organization_id
1235: and mmtt.inventory_item_id = crec.inventory_item_id
1236: and NVL(mmtt.lot_number, '@#$') = crec.lot_number
1237: and mmtt.subinventory_code = crec.subinventory_code

Line 1245: FROM mtl_material_transactions_temp mmtt2

1241: and mmtt.transaction_source_type_id = 13 -- Inventory
1242: and crec.quantity = ((-1) * mmtt.transaction_quantity)
1243: and mmtt.transaction_date = (
1244: SELECT max(mmtt2.transaction_date)
1245: FROM mtl_material_transactions_temp mmtt2
1246: WHERE mmtt2.organization_id = crec.organization_id
1247: and mmtt2.inventory_item_id = crec.inventory_item_id
1248: and NVL(mmtt2.lot_number, '@#$') = crec.lot_number
1249: and mmtt2.subinventory_code = crec.subinventory_code

Line 1697: FROM mtl_material_transactions_temp mmtt

1693:
1694: lprocLocation := 40;
1695:
1696: SELECT 0 into x_dummy -- Fine if it satisfies this condition.
1697: FROM mtl_material_transactions_temp mmtt
1698: WHERE mmtt.organization_id = crec.organization_id
1699: and mmtt.inventory_item_id = crec.inventory_item_id
1700: and NVL(mmtt.lot_number, '@#$') = crec.lot_number
1701: and mmtt.subinventory_code = crec.subinventory_code

Line 1709: FROM mtl_material_transactions_temp mmtt2

1705: and mmtt.transaction_source_type_id = 13 -- Inventory
1706: and crec.quantity = ((-1) * mmtt.transaction_quantity)
1707: and mmtt.transaction_date = (
1708: SELECT max(mmtt2.transaction_date)
1709: FROM mtl_material_transactions_temp mmtt2
1710: WHERE mmtt2.organization_id = crec.organization_id
1711: and mmtt2.inventory_item_id = crec.inventory_item_id
1712: and NVL(mmtt2.lot_number, '@#$') = crec.lot_number
1713: and mmtt2.subinventory_code = crec.subinventory_code

Line 4323: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

4319: l_stmt_num :=10;
4320: Set_Vars;
4321:
4322: --commented out by abedajna for perf. tuning
4323: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
4324: **INTO X_Temp_Id
4325: **FROM DUAL;
4326: */
4327:

Line 4383: INSERT INTO mtl_material_transactions_temp

4379: /*EA#1754109*/
4380:
4381:
4382: l_stmt_num :=40;
4383: INSERT INTO mtl_material_transactions_temp
4384: (last_update_date,
4385: creation_date,
4386: last_updated_by,
4387: created_by,

Line 4440: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */

4436: X_Reference, /* TRANSACTION_REFERENCE */
4437: 'Y', /* PROCESS_FLAG */
4438: 'Y', /* POSTING_FLAG */
4439: -- abb X_temp_id, /* Transaction Temp Id */
4440: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */
4441: X_revision,
4442: X_Dist_Acct_Id, /* distribution_account_id */
4443: 'WSM', /* Source Code */
4444: X_Source_Line_Id /* Transaction Id in WLSMI table */

Line 4551: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

4547:
4548: l_stmt_num :=10;
4549:
4550: --commented out by abedajna for perf. tuning
4551: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
4552: **INTO X_Temp_Id
4553: **FROM DUAL;
4554: */
4555:

Line 4603: INSERT INTO mtl_material_transactions_temp

4599:
4600: l_stmt_num :=40;
4601:
4602:
4603: INSERT INTO mtl_material_transactions_temp
4604: (last_update_date,
4605: creation_date,
4606: last_updated_by,
4607: created_by,

Line 4660: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */

4656: X_Reference, /* TRANSACTION_REFERENCE */
4657: 'Y', /* PROCESS_FLAG */
4658: 'Y', /* POSTING_FLAG */
4659: -- abb X_temp_id, /* Transaction Temp Id */
4660: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */
4661: X_Dist_Acct_Id, /* distribution account id */
4662: 'WSM', /* Source Code */
4663: X_Source_Line_Id /* Transaction Id in WLSMI table */
4664: /*BA#IIIP*/