APPS.JAI_INV_MMT_TRIGGER_PKG dependencies on MTL_TRANSACTION_TYPES

Line 226: FROM mtl_transaction_types

222:
223: CURSOR fetch_type_name(v_transaction_type_id IN NUMBER)
224: IS
225: SELECT transaction_type_name
226: FROM mtl_transaction_types
227: WHERE transaction_source_type_id = v_transaction_type_id;
228:
229: -- cbabu 25/07/02 for Bug#2480524, start
230: /*Commented for bug #12615773 Start */

Line 236: FROM mtl_transaction_types

232: v_misc_issue_rg_update NUMBER;
233: CURSOR c_txn_type_id(v_transaction_type_name IN VARCHAR2)
234: IS
235: SELECT transaction_type_id
236: FROM mtl_transaction_types
237: WHERE transaction_type_name = v_transaction_type_name;
238: -- cbabu 25/07/02 for Bug#2480524, end
239:
240: --Start, PROJECTS COSTING IMPL Bug#6012567(5765161)

Line 244: FROM mtl_transaction_types

240: --Start, PROJECTS COSTING IMPL Bug#6012567(5765161)
241: CURSOR c_projects_flag(cp_transaction_type_id IN number)
242: IS
243: SELECT nvl(type_class,-1) projects_flag
244: FROM mtl_transaction_types
245: WHERE transaction_type_id = cp_transaction_type_id;
246:
247: ln_projects_flag mtl_transaction_types.type_class%type; /* PROJECTS COSTING IMPL */
248: /* End, PROJECTS COSTING IMPL Bug#6012567 (5765161)*/

Line 247: ln_projects_flag mtl_transaction_types.type_class%type; /* PROJECTS COSTING IMPL */

243: SELECT nvl(type_class,-1) projects_flag
244: FROM mtl_transaction_types
245: WHERE transaction_type_id = cp_transaction_type_id;
246:
247: ln_projects_flag mtl_transaction_types.type_class%type; /* PROJECTS COSTING IMPL */
248: /* End, PROJECTS COSTING IMPL Bug#6012567 (5765161)*/
249: /*Commented for bug #12615773 End */
250:
251: CURSOR get_pr_uom_cur (v_item_id IN NUMBER, v_org_id IN NUMBER)