APPS.JL_JLBRRINV_XMLP_PKG dependencies on RA_CUSTOMER_TRX

Line 113: RA_CUSTOMER_TRX_LINES RACTL,

109: ,FND_NUMBER.CANONICAL_TO_NUMBER(RACTL.GLOBAL_ATTRIBUTE11)
110: ,0))
111: INTO X_ICMS_TAX_AMOUNT,X_ICMS_TAX_RATE,X_ICMS_TAX_BASE_AMOUNT
112: FROM
113: RA_CUSTOMER_TRX_LINES RACTL,
114: AR_VAT_TAX ARVT
115: WHERE RACTL.LINE_TYPE = 'TAX'
116: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
117: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID

Line 140: RA_CUSTOMER_TRX_LINES RACTL,

136: ,RACTL.EXTENDED_AMOUNT
137: ,0))
138: INTO X_ISS_TAX_AMOUNT
139: FROM
140: RA_CUSTOMER_TRX_LINES RACTL,
141: AR_VAT_TAX ARVT
142: WHERE RACTL.LINE_TYPE = 'TAX'
143: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
144: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID

Line 165: RA_CUSTOMER_TRX_LINES RACTL,

161: ,RACTL.EXTENDED_AMOUNT
162: ,0))
163: INTO X_IRJ_TAX_AMOUNT
164: FROM
165: RA_CUSTOMER_TRX_LINES RACTL,
166: AR_VAT_TAX ARVT
167: WHERE RACTL.LINE_TYPE = 'TAX'
168: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
169: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID

Line 195: RA_CUSTOMER_TRX_LINES RACTL,

191: ,FND_NUMBER.CANONICAL_TO_NUMBER(RACTL.GLOBAL_ATTRIBUTE11)
192: ,0))
193: INTO X_ICMSST_TAX_AMOUNT,X_ICMSST_TAX_BASE_AMOUNT
194: FROM
195: RA_CUSTOMER_TRX_LINES RACTL,
196: AR_VAT_TAX ARVT
197: WHERE RACTL.LINE_TYPE = 'TAX'
198: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
199: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID

Line 245: L_TRX_REC RA_CUSTOMER_TRX%ROWTYPE;

241: PROCEDURE PRINTING_COUNT(X_TRX_NUMBER IN VARCHAR2
242: ,CUST_TRX_ID IN NUMBER) IS
243: FLAG_PRINT VARCHAR2(1);
244: P_COUNT NUMBER;
245: L_TRX_REC RA_CUSTOMER_TRX%ROWTYPE;
246: BEGIN
247: BEGIN
248: SELECT
249: PRINTING_PENDING,

Line 254: RA_CUSTOMER_TRX

250: NVL(PRINTING_COUNT
251: ,0)
252: INTO FLAG_PRINT,P_COUNT
253: FROM
254: RA_CUSTOMER_TRX
255: WHERE TRX_NUMBER = X_TRX_NUMBER
256: AND CUSTOMER_TRX_ID = CUST_TRX_ID;
257: END;
258: IF NVL(FLAG_PRINT

Line 425: RA_CUSTOMER_TRX_LINES RACTL,

421: ,NULL
422: ,PRODUCT_FISC_CLASSIFICATION
423: ,PRODUCT_CATEGORY) FISCAL_CLASS_CODE
424: FROM
425: RA_CUSTOMER_TRX_LINES RACTL,
426: ZX_LINES_DET_FACTORS ZLD
427: WHERE RACTL.CUSTOMER_TRX_ID = C_CUSTOMER_TRX_ID
428: AND ZLD.APPLICATION_ID = 222
429: AND ZLD.ENTITY_CODE = 'TRANSACTIONS'

Line 444: RA_CUSTOMER_TRX RACT

440: ARL.MEANING
441: INTO X_MEANING
442: FROM
443: AR_LOOKUPS ARL,
444: RA_CUSTOMER_TRX RACT
445: WHERE RACT.STATUS_TRX = 'VD'
446: AND ARL.LOOKUP_TYPE = 'INVOICE_TRX_STATUS'
447: AND ARL.LOOKUP_CODE = C_STATUS_TRX;
448: EXCEPTION

Line 519: RA_CUSTOMER_TRX_LINES RACTL,

515: ,0)
516: ,0))
517: INTO X_IPI_TAX_AMOUNT,X_IPI_TAX_RATE
518: FROM
519: RA_CUSTOMER_TRX_LINES RACTL,
520: AR_VAT_TAX ARVT
521: WHERE RACTL.LINE_TYPE = 'TAX'
522: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
523: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID