APPS.INV_INVTRHAN_XMLP_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 71: MTL_MATERIAL_TRANSACTIONS

67: NVL(MIN(TRANSACTION_ID)
68: ,0)
69: INTO MY_MIN_TRX_ID
70: FROM
71: MTL_MATERIAL_TRANSACTIONS
72: WHERE ORGANIZATION_ID = MY_ORG_ID
73: AND INVENTORY_ITEM_ID = MY_ITEM_ID
74: AND ( SUBINVENTORY_CODE in (
75: SELECT

Line 92: MTL_MATERIAL_TRANSACTIONS

88: SELECT
89: PRIOR_COST
90: INTO MY_HIS_VALUE
91: FROM
92: MTL_MATERIAL_TRANSACTIONS
93: WHERE ORGANIZATION_ID = MY_ORG_ID
94: AND INVENTORY_ITEM_ID = MY_ITEM_ID
95: AND TRANSACTION_ID = MY_MIN_TRX_ID;
96: RETURN (ROUND(MY_TARGET_QTY * MY_HIS_VALUE

Line 440: from mtl_material_transactions mmt,

436: sum(decode(mtst.transaction_source_type_id,' || STYPE1 || ',0,' || STYPE2 || ',0,' || STYPE3 || ',0,' || STYPE4 || ',0,primary_quantity )) other,
437: 0 cur_qty_val,
438: 0 cur_qty,
439: -sum(primary_quantity) target_qty
440: from mtl_material_transactions mmt,
441: mtl_txn_source_types mtst,
442: mtl_parameters mp
443: where mmt.organization_id = ' || VAR_ORG || '
444: and mp.organization_id = ' || VAR_ORG || '

Line 538: from mtl_material_transactions mmt,

534: ) other,
535: 0 cur_qty_val,
536: 0 cur_qty,
537: -sum(primary_quantity) target_qty
538: from mtl_material_transactions mmt,
539: mtl_txn_source_types mtst,
540: mtl_parameters mp,
541: cst_item_costs_for_gl_view cst
542: where mmt.organization_id = ' || VAR_ORG || '

Line 826: MTL_MATERIAL_TRANSACTIONS

822: NVL(MIN(TRANSACTION_ID)
823: ,0)
824: INTO MY_MIN_TRX_ID
825: FROM
826: MTL_MATERIAL_TRANSACTIONS
827: WHERE ORGANIZATION_ID = MY_ORG_ID
828: AND INVENTORY_ITEM_ID = MY_ITEM_ID
829: AND TRANSACTION_DATE > TO_DATE(MY_HIS_DATE
830: ,'DD-MON-RRRR');

Line 839: MTL_MATERIAL_TRANSACTIONS

835: NVL(PRIOR_COST
836: ,0)
837: INTO MY_HIS_VALUE
838: FROM
839: MTL_MATERIAL_TRANSACTIONS
840: WHERE ORGANIZATION_ID = MY_ORG_ID
841: AND INVENTORY_ITEM_ID = MY_ITEM_ID
842: AND TRANSACTION_ID = MY_MIN_TRX_ID;
843: END IF;

Line 926: MTL_MATERIAL_TRANSACTIONS

922: NVL(MIN(TRANSACTION_ID)
923: ,0)
924: INTO MY_MIN_TRX_ID
925: FROM
926: MTL_MATERIAL_TRANSACTIONS
927: WHERE ORGANIZATION_ID = MY_ORG_ID
928: AND INVENTORY_ITEM_ID = MY_ITEM_ID
929: AND TRANSACTION_DATE > TO_DATE(MY_HIS_DATE
930: ,'DD-MON-RRRR');

Line 938: MTL_MATERIAL_TRANSACTIONS

934: SELECT
935: PRIOR_COST
936: INTO MY_HIS_VALUE
937: FROM
938: MTL_MATERIAL_TRANSACTIONS
939: WHERE ORGANIZATION_ID = MY_ORG_ID
940: AND INVENTORY_ITEM_ID = MY_ITEM_ID
941: AND TRANSACTION_ID = MY_MIN_TRX_ID;
942: END IF;

Line 1024: MTL_MATERIAL_TRANSACTIONS

1020: NVL(MIN(TRANSACTION_ID)
1021: ,0)
1022: INTO MY_MIN_TRX_ID
1023: FROM
1024: MTL_MATERIAL_TRANSACTIONS
1025: WHERE ORGANIZATION_ID = MY_ORG_ID
1026: AND INVENTORY_ITEM_ID = MY_ITEM_ID
1027: AND TRANSACTION_DATE > TO_DATE(MY_HIS_DATE
1028: ,'DD-MON-RRRR');

Line 1036: MTL_MATERIAL_TRANSACTIONS

1032: SELECT
1033: PRIOR_COST
1034: INTO MY_HIS_VALUE
1035: FROM
1036: MTL_MATERIAL_TRANSACTIONS
1037: WHERE ORGANIZATION_ID = MY_ORG_ID
1038: AND INVENTORY_ITEM_ID = MY_ITEM_ID
1039: AND TRANSACTION_ID = MY_MIN_TRX_ID;
1040: END IF;

Line 1122: MTL_MATERIAL_TRANSACTIONS

1118: NVL(MIN(TRANSACTION_ID)
1119: ,0)
1120: INTO MY_MIN_TRX_ID
1121: FROM
1122: MTL_MATERIAL_TRANSACTIONS
1123: WHERE ORGANIZATION_ID = MY_ORG_ID
1124: AND INVENTORY_ITEM_ID = MY_ITEM_ID
1125: AND TRANSACTION_DATE > TO_DATE(MY_HIS_DATE
1126: ,'DD-MON-RRRR');

Line 1134: MTL_MATERIAL_TRANSACTIONS

1130: SELECT
1131: PRIOR_COST
1132: INTO MY_HIS_VALUE
1133: FROM
1134: MTL_MATERIAL_TRANSACTIONS
1135: WHERE ORGANIZATION_ID = MY_ORG_ID
1136: AND INVENTORY_ITEM_ID = MY_ITEM_ID
1137: AND TRANSACTION_ID = MY_MIN_TRX_ID;
1138: END IF;

Line 1220: MTL_MATERIAL_TRANSACTIONS

1216: NVL(MIN(TRANSACTION_ID)
1217: ,0)
1218: INTO MY_MIN_TRX_ID
1219: FROM
1220: MTL_MATERIAL_TRANSACTIONS
1221: WHERE ORGANIZATION_ID = MY_ORG_ID
1222: AND INVENTORY_ITEM_ID = MY_ITEM_ID
1223: AND TRANSACTION_DATE > TO_DATE(MY_HIS_DATE
1224: ,'DD-MON-RRRR');

Line 1232: MTL_MATERIAL_TRANSACTIONS

1228: SELECT
1229: PRIOR_COST
1230: INTO MY_HIS_VALUE
1231: FROM
1232: MTL_MATERIAL_TRANSACTIONS
1233: WHERE ORGANIZATION_ID = MY_ORG_ID
1234: AND INVENTORY_ITEM_ID = MY_ITEM_ID
1235: AND TRANSACTION_ID = MY_MIN_TRX_ID;
1236: END IF;