DBA Data[Home] [Help]

APPS.ONT_OEXOEORS_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 354: OE_TRANSACTION_TYPES_TL OEOT

350: SELECT
351: OEOT.NAME
352: INTO L_ORDER_TYPE
353: FROM
354: OE_TRANSACTION_TYPES_TL OEOT
355: WHERE OEOT.TRANSACTION_TYPE_ID = P_RETURN_TYPE
356: AND OEOT.LANGUAGE = USERENV('LANG');
357: END IF;
358: IF (P_RETURN_LINE_TYPE IS NOT NULL) THEN

Line 364: OE_TRANSACTION_TYPES_TL OEOT

360: SELECT
361: OEOT.NAME
362: INTO L_LINE_TYPE
363: FROM
364: OE_TRANSACTION_TYPES_TL OEOT
365: WHERE OEOT.TRANSACTION_TYPE_ID = P_RETURN_LINE_TYPE
366: AND OEOT.LANGUAGE = USERENV('LANG');
367: END IF;
368: IF (P_LINE_CATEGORY = 'CREDIT') OR (P_LINE_CATEGORY IS NULL) THEN