APPS.JA_JAINARE1_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 156: OE_ORDER_HEADERS_ALL

152: CONVERSION_TYPE_CODE,
153: CONVERSION_RATE,
154: TRANSACTIONAL_CURR_CODE
155: FROM
156: OE_ORDER_HEADERS_ALL
157: WHERE HEADER_ID = P_HEADER_ID;
158: CURSOR C_ORDER_LINE_SELLING_PRICE(P_LINE_ID IN NUMBER,P_HEADER_ID IN NUMBER) IS
159: SELECT
160: UNIT_SELLING_PRICE

Line 166: V_CONVERSION_TYPE OE_ORDER_HEADERS_ALL.CONVERSION_TYPE_CODE%TYPE;

162: OE_ORDER_LINES_ALL
163: WHERE LINE_ID = P_LINE_ID
164: AND HEADER_ID = P_HEADER_ID;
165: V_CONFIRM_DATE DATE;
166: V_CONVERSION_TYPE OE_ORDER_HEADERS_ALL.CONVERSION_TYPE_CODE%TYPE;
167: V_TRANS_CURR OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE;
168: V_CONVERSION C_CONVERSION%ROWTYPE;
169: V_CONVERSION_RATE NUMBER;
170: V_SELLING_PRICE NUMBER;

Line 167: V_TRANS_CURR OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE;

163: WHERE LINE_ID = P_LINE_ID
164: AND HEADER_ID = P_HEADER_ID;
165: V_CONFIRM_DATE DATE;
166: V_CONVERSION_TYPE OE_ORDER_HEADERS_ALL.CONVERSION_TYPE_CODE%TYPE;
167: V_TRANS_CURR OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE;
168: V_CONVERSION C_CONVERSION%ROWTYPE;
169: V_CONVERSION_RATE NUMBER;
170: V_SELLING_PRICE NUMBER;
171: V_SELLING_VALUE NUMBER(20,3);