DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_MTL_TRXS

Line 1511: jai_mtl_trxs c /* jai_mtl_trxs_temp is modified as jai_mtl_trxs by Vijay for ReArch. bug#2942973 */

1507: , b.inclusive_tax_flag --Add by Kevin for inclusive tax Dec 12, 2007
1508: FROM
1509: jai_cmn_document_taxes a ,
1510: jai_cmn_taxes_all b ,
1511: jai_mtl_trxs c /* jai_mtl_trxs_temp is modified as jai_mtl_trxs by Vijay for ReArch. bug#2942973 */
1512: WHERE
1513: a.source_doc_line_id = p_line_id AND
1514: a.tax_id = b.tax_id AND
1515: a.source_doc_type = 'INTERORG_XFER' AND

Line 1583: FROM jai_mtl_trxs /* jai_mtl_trxs_temp is modified as jai_mtl_trxs by Vijay for ReArch. bug#2942973 */

1579: /* SELECT transaction_Quantity quantity, Selling_Price unit_Selling_price , uom_code Unit_Code, Inventory_Item_Id */
1580: SELECT decode(quantity,0,1,quantity), selling_price unit_Selling_price , transaction_uom Unit_Code, Inventory_Item_Id, vat_assessable_value
1581: , nvl(selling_price,0)*nvl(quantity,0) line_amount --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1582: , nvl(assessable_value,0) assessable_value --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1583: FROM jai_mtl_trxs /* jai_mtl_trxs_temp is modified as jai_mtl_trxs by Vijay for ReArch. bug#2942973 */
1584: WHERE transaction_temp_id = p_line_id;
1585:
1586: CURSOR Fetch_Exempt_Cur( AddressId IN NUMBER ) IS -- OE Side
1587: SELECT NVL( Exempt, 'N' )