APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_AR_TRX_LINES

Line 519: FROM JAI_OPM_SO_PICK_LINES -- JAI_AR_TRX_LINES

515: AND A.uom_class = B.uom_class;
516:
517: CURSOR Fetch_Dtls_Cur IS -- OE Side
518: SELECT QUANTITY,price
519: FROM JAI_OPM_SO_PICK_LINES -- JAI_AR_TRX_LINES
520: WHERE Order_id = p_line_id;
521:
522: CURSOR Fetch_Dtls1_Cur IS -- AR Side
523: SELECT Quantity, Unit_Selling_Price, Unit_Code, Inventory_Item_Id

Line 524: FROM JAI_AR_TRX_LINES

520: WHERE Order_id = p_line_id;
521:
522: CURSOR Fetch_Dtls1_Cur IS -- AR Side
523: SELECT Quantity, Unit_Selling_Price, Unit_Code, Inventory_Item_Id
524: FROM JAI_AR_TRX_LINES
525: WHERE Customer_Trx_Line_Id = p_line_id;
526:
527: CURSOR Fetch_Exempt_Cur( AddressId IN NUMBER ) IS -- OE Side
528: SELECT NVL( Exempt, 'N' )

Line 585: -- FROM JAI_AR_TRX_LINES

581: AND Receipt_ID IS NOT NULL;
582:
583: -- CURSOR Fetch_Matched_Qty_AR_Cur IS
584: -- SELECT matched_quantity
585: -- FROM JAI_AR_TRX_LINES
586: -- WHERE Customer_Trx_Line_Id = p_ref_line_id;
587:
588: CURSOR Excise_Duty_Rate_Cur IS
589: SELECT rate_per_unit ,PRIMARY_UOM_CODE

Line 1181: FROM JAI_AR_TRX_LINES

1177: v_shipment_line_id Number; --added by Vijay on 9-Oct-2001 for Tar# 9445972.700
1178:
1179: /* CURSOR Fetch_Matched_Qty_AR_Cur IS
1180: SELECT matched_quantity
1181: FROM JAI_AR_TRX_LINES
1182: WHERE Customer_Trx_Line_Id = p_ref_line_id;*/
1183:
1184: CURSOR Fetch_AR_Line_Info_Cur IS
1185: SELECT nvl(quantity * nvl(assessable_value, line_amount),0) assessable_value, line_amount, unit_code, inventory_item_id, quantity,

Line 1187: FROM JAI_AR_TRX_LINES

1183:
1184: CURSOR Fetch_AR_Line_Info_Cur IS
1185: SELECT nvl(quantity * nvl(assessable_value, line_amount),0) assessable_value, line_amount, unit_code, inventory_item_id, quantity,
1186: tax_category_id, customer_trx_id, creation_date, created_by, last_updated_by, last_update_login
1187: FROM JAI_AR_TRX_LINES
1188: WHERE Customer_Trx_Line_Id = p_ref_line_id;
1189:
1190: CURSOR Chk_New_Added_Tax_Cur IS
1191: SELECT NVL( MAX( Tax_Line_No ), 0 )

Line 1665: FROM JAI_AR_TRX_LINES

1661: , nvl(assessable_value,0)*nvl(quantity,0) assessable_value --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1662: , nvl(vat_assessable_value,0) vat_assessable_vale --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1663: , nvl(vat_reversal_price, 0) vat_reversal_price --added for bug#8887871
1664: , nvl(gst_assessable_value,0) gst_assessable_value --Add by Xiao for GST refer to bug#10043656.
1665: FROM JAI_AR_TRX_LINES
1666: WHERE Customer_Trx_Line_Id = p_line_id;
1667:
1668: CURSOR Fetch_Dtls_xfer_Cur IS -- Inter Org XFER Side 6030615
1669: /* SELECT transaction_Quantity quantity, Selling_Price unit_Selling_price , uom_code Unit_Code, Inventory_Item_Id */