DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_TRX_LINES

Line 925: FROM JAI_AR_TRX_LINES

921: -- DISTINCT Key Word is not required, Vijay Shankar for bug # 3515883
922: -- SELECT DISTINCT QUANTITY, TAX_CATEGORY_ID, ASSESSABLE_VALUE
923: SELECT QUANTITY, TAX_CATEGORY_ID, ASSESSABLE_VALUE
924: INTO AQUANTITY, ATAX_CATEGORY_ID, OLD_ASSESSABLE_VALUE
925: FROM JAI_AR_TRX_LINES
926: WHERE CUSTOMER_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID;
927: EXCEPTION
928: WHEN OTHERS THEN
929: NULL;

Line 1129: FROM JAI_AR_TRX_LINES

1125:
1126: v_statement_id := '26';
1127: SELECT UNIT_SELLING_PRICE
1128: INTO I_UNIT_SELLING_PRICE
1129: FROM JAI_AR_TRX_LINES
1130: WHERE CUSTOMER_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID;
1131:
1132: OLD_INVOICE_AMOUNT := I_UNIT_SELLING_PRICE*AQUANTITY;
1133: