APPS.JA_JAINMCEN_XMLP_PKG dependencies on RCV_TRANSACTIONS

Line 114: CURSOR CUR_SOB_ID(CP_ORGANIZATION_ID IN RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE) IS

110: ,EXCISE_INVOICE_NO IN VARCHAR2
111: ,EXCISE_INVOICE_DATE IN DATE
112: ,ORGANIZATION_ID IN NUMBER
113: ,LOCATION_ID IN NUMBER) RETURN NUMBER IS
114: CURSOR CUR_SOB_ID(CP_ORGANIZATION_ID IN RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE) IS
115: SELECT
116: SET_OF_BOOKS_ID
117: FROM
118: ORG_ORGANIZATION_DEFINITIONS

Line 121: CURSOR CUR_RECEIPT_LINE_AMOUNT(CP_TRANSACTION_ID IN RCV_TRANSACTIONS.TRANSACTION_ID%TYPE) IS

117: FROM
118: ORG_ORGANIZATION_DEFINITIONS
119: WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID
120: AND ROWNUM = 1;
121: CURSOR CUR_RECEIPT_LINE_AMOUNT(CP_TRANSACTION_ID IN RCV_TRANSACTIONS.TRANSACTION_ID%TYPE) IS
122: SELECT
123: A.QTY_RECEIVED * B.PO_UNIT_PRICE
124: FROM
125: JAI_RCV_LINES A,

Line 126: RCV_TRANSACTIONS B

122: SELECT
123: A.QTY_RECEIVED * B.PO_UNIT_PRICE
124: FROM
125: JAI_RCV_LINES A,
126: RCV_TRANSACTIONS B
127: WHERE A.TRANSACTION_ID = B.TRANSACTION_ID;
128: V_SOB_ID ORG_ORGANIZATION_DEFINITIONS.SET_OF_BOOKS_ID%TYPE;
129: V_PO_FUNC_CONV NUMBER;
130: VAMT1 NUMBER := 0;

Line 147: RCV_TRANSACTIONS RT,

143: RT.CURRENCY_CODE CCODE,
144: JTC.ADHOC_FLAG
145: FROM
146: JAI_CMN_RG_23AC_II_TRXS RG23,
147: RCV_TRANSACTIONS RT,
148: JAI_RCV_LINE_TAXES RTL,
149: JAI_CMN_TAXES_ALL JTC
150: WHERE RG23.EXCISE_INVOICE_NO = cf_assessable_valueformula.EXCISE_INVOICE_NO
151: AND RG23.EXCISE_INVOICE_DATE = cf_assessable_valueformula.EXCISE_INVOICE_DATE

Line 210: RCV_TRANSACTIONS RCVT

206: SELECT
207: COUNT(1)
208: FROM
209: JAI_RCV_LINE_TAXES JRL,
210: RCV_TRANSACTIONS RCVT
211: WHERE RCVT.TRANSACTION_ID = TO_NUMBER(CP_RECEIPT_ID)
212: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
213: AND RCVT.SHIPMENT_LINE_ID = JRL.SHIPMENT_LINE_ID
214: AND UPPER(JRL.TAX_TYPE) LIKE UPPER(LV_TAX_TYPE_EXCISE);

Line 220: RCV_TRANSACTIONS RCVT

216: SELECT
217: COUNT(1)
218: FROM
219: JAI_RCV_LINE_TAXES JRL,
220: RCV_TRANSACTIONS RCVT
221: WHERE RCVT.TRANSACTION_ID = TO_NUMBER(CP_RECEIPT_ID)
222: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
223: AND RCVT.SHIPMENT_LINE_ID = JRL.SHIPMENT_LINE_ID
224: AND UPPER(JRL.TAX_TYPE) LIKE LV_TAX_TYPE_CVD;

Line 263: RCV_TRANSACTIONS RCVT,

259: SELECT
260: DISTINCT
261: JU.EC_CODE
262: FROM
263: RCV_TRANSACTIONS RCVT,
264: RCV_SHIPMENT_HEADERS RCVSH,
265: JAI_CMN_INVENTORY_ORGS JU
266: WHERE RCVT.TRANSACTION_ID = CP_RECEIPT_ID
267: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE

Line 309: RCV_TRANSACTIONS RCVT,

305: CURSOR INT_ORDER_CUR(P_RECEIPT_ID IN VARCHAR2,CP_RECEIPT_SOURCE_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS
306: SELECT
307: HRU.NAME
308: FROM
309: RCV_TRANSACTIONS RCVT,
310: RCV_SHIPMENT_HEADERS RCVSH,
311: HR_ORGANIZATION_UNITS HRU
312: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
313: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE

Line 372: RCV_TRANSACTIONS RCVT,

368: ,JHRU.TRADING
369: ,'Dealer')
370: FROM
371: JAI_CMN_INVENTORY_ORGS JHRU,
372: RCV_TRANSACTIONS RCVT,
373: RCV_SHIPMENT_HEADERS RCVSH
374: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
375: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
376: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID

Line 424: RCV_TRANSACTIONS

420: TRANSACTION_TYPE,
421: TRANSACTION_ID,
422: SHIPMENT_LINE_ID
423: FROM
424: RCV_TRANSACTIONS
425: WHERE TRANSACTION_ID = P_TRANSACTION_ID;
426: R_TRX_DTL C_TRX_DTL%ROWTYPE;
427: BEGIN
428: IF RECEIPT_ID IS NOT NULL THEN

Line 443: RCV_TRANSACTIONS

439: END IF;
440: FOR qty_rec IN (SELECT
441: PRIMARY_QUANTITY
442: FROM
443: RCV_TRANSACTIONS
444: WHERE TRANSACTION_ID = LN_RECEIVE_TRX_ID
445: OR ( TRANSACTION_TYPE = LV_CRCT_TRANSACTION
446: AND PARENT_TRANSACTION_ID = LN_RECEIVE_TRX_ID )) LOOP
447: V_QTY := V_QTY + QTY_REC.PRIMARY_QUANTITY;