APPS.OM_SETUP_VALID_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 350: FROM OE_TRANSACTION_TYPES_TL

346: ttypename VARCHAR2(255);
347: BEGIN
348: SELECT NAME
349: INTO ttypename
350: FROM OE_TRANSACTION_TYPES_TL
351: WHERE TRANSACTION_TYPE_ID = ttypeid
352: AND LANGUAGE=USERENV('LANG');
353: RETURN ttypename;
354: EXCEPTION

Line 2213: FROM OE_TRANSACTION_TYPES_TL tl, OE_TRANSACTION_TYPES_ALL b

2209: sobhr NUMBER;
2210: /* Cursor Variables */
2211: CURSOR ttypes IS
2212: SELECT tl.NAME, b.ORG_ID
2213: FROM OE_TRANSACTION_TYPES_TL tl, OE_TRANSACTION_TYPES_ALL b
2214: WHERE tl.TRANSACTION_TYPE_ID = b.TRANSACTION_TYPE_ID
2215: AND tl.LANGUAGE=USERENV('LANG')
2216: ORDER BY b.ORG_ID;
2217: ttype ttypes%ROWTYPE;

Line 2222: , OE_TRANSACTION_TYPES_TL ttl

2218: CURSOR doccats IS
2219: SELECT tta.ORG_ID, fdsc.CODE, fdsc.NAME
2220: FROM FND_DOC_SEQUENCE_CATEGORIES fdsc
2221: , OE_TRANSACTION_TYPES_ALL tta
2222: , OE_TRANSACTION_TYPES_TL ttl
2223: WHERE ttl.NAME = fdsc.NAME
2224: AND tta.TRANSACTION_TYPE_ID = ttl.TRANSACTION_TYPE_ID
2225: AND ttl.LANGUAGE=USERENV('LANG')
2226: ORDER BY tta.ORG_ID;

Line 2363: , OE_TRANSACTION_TYPES_TL tl

2359: /* Cursor Variables */
2360: CURSOR ttdisabled IS
2361: SELECT tl.NAME, b.ORG_ID
2362: FROM OE_TRANSACTION_TYPES_ALL b
2363: , OE_TRANSACTION_TYPES_TL tl
2364: WHERE ENTRY_CREDIT_CHECK_RULE_ID IS NULL
2365: AND SHIPPING_CREDIT_CHECK_RULE_ID IS NULL
2366: AND PICKING_CREDIT_CHECK_RULE_ID IS NULL
2367: AND PACKING_CREDIT_CHECK_RULE_ID IS NULL