eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ONT_OEXOESOS_XMLP_PKG dependencies on DUAL

Line 259: DUAL;

255: SELECT
256: USERENV('LANG')
257: INTO P_LANG
258: FROM
259: DUAL;
260: IF P_SALESREP_LOW IS NOT NULL AND P_SALESREP_HIGH IS NOT NULL THEN
261: IF (P_SALESREP_LOW = P_SALESREP_HIGH) THEN
262: LP_SALESREP := ' and sr.name = :p_salesrep_low ';
263: ELSE

Line 539: DUAL;

535: SELECT
536: C_GL_CONV_RATE * EXTENDED_PRICE
537: INTO AMOUNT
538: FROM
539: DUAL;
540: RETURN (AMOUNT);
541: ELSE
542: RETURN (0);
543: END IF;

Line 580: DUAL;

576: SELECT
577: ( ( S_LISTP_CURR - 2 * S_LISTP_CURR_RMA ) - ( S_SELLP_CURR - 2 * S_SELLP_CURR_RMA ) ) / ( S_LISTP_CURR - 2 * S_LISTP_CURR_RMA ) * 100
578: INTO DISCOUNT
579: FROM
580: DUAL;
581: RETURN (DISCOUNT);
582: ELSE
583: RETURN (0);
584: END IF;

Line 606: DUAL;

602: SELECT
603: ( ( S_LISTP_SR - 2 * S_LISTP_SR_RMA ) - ( S_SELLP_SR - 2 * S_SELLP_SR_RMA ) ) / ( S_LISTP_SR - 2 * S_LISTP_SR_RMA ) * 100
604: INTO DISCOUNT
605: FROM
606: DUAL;
607: RETURN (DISCOUNT);
608: ELSE
609: RETURN (0);
610: END IF;

Line 628: DUAL;

624: SELECT
625: ( S_LISTP_CUST - S_SELLP_CUST ) / S_LISTP_CUST * 100
626: INTO DISCOUNT
627: FROM
628: DUAL;
629: RETURN (DISCOUNT);
630: ELSE
631: RETURN (0);
632: END IF;

Line 651: DUAL;

647: SELECT
648: C_GL_CONV_RATE * SALE_PRICE
649: INTO AMOUNT
650: FROM
651: DUAL;
652: RETURN (AMOUNT);
653: ELSE
654: RETURN (0);
655: END IF;

Line 676: DUAL;

672: SELECT
673: ( S_LISTP_ORDER - S_SELLP_ORDER ) / S_LISTP_ORDER * 100
674: INTO DISCOUNT
675: FROM
676: DUAL;
677: RETURN (DISCOUNT);
678: ELSE
679: RETURN (0);
680: END IF;

Line 702: DUAL;

698: SELECT
699: ( S_PRICE_CURR - 2 * S_PRICE_CURR_RMA )
700: INTO TOTAL_NET
701: FROM
702: DUAL;
703: RETURN (TOTAL_NET);
704: END;
705: RETURN NULL;
706: END S_PRICE_CURR_NETFORMULA;

Line 810: DUAL;

806: SELECT
807: ( C_SALESREP_TOTAL - 2 * C_SALESREP_TOTAL_RMA )
808: INTO TOTAL_NET
809: FROM
810: DUAL;
811: RETURN (TOTAL_NET);
812: END;
813: RETURN NULL;
814: END S_SALESREP_TOTAL_NETFORMULA;

Line 850: DUAL;

846: SELECT
847: ( S_LISTP_PERIODICITY - S_SELLP_PERIODICITY ) / S_LISTP_PERIODICITY * 100
848: INTO DISCOUNT
849: FROM
850: DUAL;
851: RETURN (DISCOUNT);
852: ELSE
853: RETURN (0);
854: END IF;