APPS.INV_INVTRHAN_XMLP_PKG dependencies on MTL_TXN_SOURCE_TYPES

Line 126: MTL_TXN_SOURCE_TYPES

122: ,0
123: ,14)
124: INTO NAME
125: FROM
126: MTL_TXN_SOURCE_TYPES
127: WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;
128: RETURN (NAME);
129: EXCEPTION
130: WHEN NO_DATA_FOUND THEN

Line 150: MTL_TXN_SOURCE_TYPES

146: ,0
147: ,14)
148: INTO NAME
149: FROM
150: MTL_TXN_SOURCE_TYPES
151: WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;
152: RETURN (NAME);
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN

Line 174: MTL_TXN_SOURCE_TYPES

170: ,0
171: ,13)
172: INTO NAME
173: FROM
174: MTL_TXN_SOURCE_TYPES
175: WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;
176: RETURN (NAME);
177: EXCEPTION
178: WHEN NO_DATA_FOUND THEN

Line 198: MTL_TXN_SOURCE_TYPES

194: ,0
195: ,13)
196: INTO NAME
197: FROM
198: MTL_TXN_SOURCE_TYPES
199: WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;
200: RETURN (NAME);
201: EXCEPTION
202: WHEN NO_DATA_FOUND THEN

Line 222: MTL_TXN_SOURCE_TYPES

218: ,0
219: ,11)
220: INTO NAME
221: FROM
222: MTL_TXN_SOURCE_TYPES
223: WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;
224: RETURN (NAME);
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN

Line 441: mtl_txn_source_types mtst,

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 || '
445: /*and transaction_date >= to_date(''' || HIST_DATE || ''' , ''DD-MON-RRRR'' ) + 1 --GSCC change hist_date + 1 */

Line 539: mtl_txn_source_types mtst,

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 || '
543: and mp.organization_id = ' || VAR_ORG || '