APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_AR_TRX_LINES

Line 460: FROM JAI_OPM_SO_PICK_LINES -- JAI_AR_TRX_LINES

456: AND A.uom_class = B.uom_class;
457:
458: CURSOR Fetch_Dtls_Cur IS -- OE Side
459: SELECT QUANTITY,price
460: FROM JAI_OPM_SO_PICK_LINES -- JAI_AR_TRX_LINES
461: WHERE Order_id = p_line_id;
462:
463: CURSOR Fetch_Dtls1_Cur IS -- AR Side
464: SELECT Quantity, Unit_Selling_Price, Unit_Code, Inventory_Item_Id

Line 465: FROM JAI_AR_TRX_LINES

461: WHERE Order_id = p_line_id;
462:
463: CURSOR Fetch_Dtls1_Cur IS -- AR Side
464: SELECT Quantity, Unit_Selling_Price, Unit_Code, Inventory_Item_Id
465: FROM JAI_AR_TRX_LINES
466: WHERE Customer_Trx_Line_Id = p_line_id;
467:
468: CURSOR Fetch_Exempt_Cur( AddressId IN NUMBER ) IS -- OE Side
469: SELECT NVL( Exempt, 'N' )

Line 526: -- FROM JAI_AR_TRX_LINES

522: AND Receipt_ID IS NOT NULL;
523:
524: -- CURSOR Fetch_Matched_Qty_AR_Cur IS
525: -- SELECT matched_quantity
526: -- FROM JAI_AR_TRX_LINES
527: -- WHERE Customer_Trx_Line_Id = p_ref_line_id;
528:
529: CURSOR Excise_Duty_Rate_Cur IS
530: SELECT rate_per_unit ,PRIMARY_UOM_CODE

Line 1122: FROM JAI_AR_TRX_LINES

1118: v_shipment_line_id Number; --added by Vijay on 9-Oct-2001 for Tar# 9445972.700
1119:
1120: /* CURSOR Fetch_Matched_Qty_AR_Cur IS
1121: SELECT matched_quantity
1122: FROM JAI_AR_TRX_LINES
1123: WHERE Customer_Trx_Line_Id = p_ref_line_id;*/
1124:
1125: CURSOR Fetch_AR_Line_Info_Cur IS
1126: SELECT nvl(quantity * nvl(assessable_value, line_amount),0) assessable_value, line_amount, unit_code, inventory_item_id, quantity,

Line 1128: FROM JAI_AR_TRX_LINES

1124:
1125: CURSOR Fetch_AR_Line_Info_Cur IS
1126: SELECT nvl(quantity * nvl(assessable_value, line_amount),0) assessable_value, line_amount, unit_code, inventory_item_id, quantity,
1127: tax_category_id, customer_trx_id, creation_date, created_by, last_updated_by, last_update_login
1128: FROM JAI_AR_TRX_LINES
1129: WHERE Customer_Trx_Line_Id = p_ref_line_id;
1130:
1131: CURSOR Chk_New_Added_Tax_Cur IS
1132: SELECT NVL( MAX( Tax_Line_No ), 0 )

Line 1575: FROM JAI_AR_TRX_LINES

1571: SELECT Quantity, Unit_Selling_Price, Unit_Code, Inventory_Item_Id
1572: , nvl(line_amount, 0) line_amount --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1573: , nvl(assessable_value,0)*nvl(quantity,0) assessable_value --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1574: , nvl(vat_assessable_value,0) vat_assessable_vale --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1575: FROM JAI_AR_TRX_LINES
1576: WHERE Customer_Trx_Line_Id = p_line_id;
1577:
1578: CURSOR Fetch_Dtls_xfer_Cur IS -- Inter Org XFER Side 6030615
1579: /* SELECT transaction_Quantity quantity, Selling_Price unit_Selling_price , uom_code Unit_Code, Inventory_Item_Id */