DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_MTL_TRXS

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

1583: FROM
1584: jai_cmn_document_taxes a ,
1585: jai_regime_tax_types_v aa , -- Add by Xiao for GST refer to bug#10043656.
1586: jai_cmn_taxes_all b ,
1587: jai_mtl_trxs c /* jai_mtl_trxs_temp is modified as jai_mtl_trxs by Vijay for ReArch. bug#2942973 */
1588: WHERE
1589: a.source_doc_line_id = p_line_id AND
1590: a.tax_id = b.tax_id AND
1591: aa.tax_type(+) = b.tax_type AND -- Add by Xiao for GST refer to bug#10043656.

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

1670: SELECT decode(quantity,0,1,quantity), selling_price unit_Selling_price , transaction_uom Unit_Code, Inventory_Item_Id, vat_assessable_value
1671: , nvl(selling_price,0)*nvl(quantity,0) line_amount --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1672: , nvl(assessable_value,0) assessable_value --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1673: , nvl(gst_assessable_value,0) gst_assessable_value --Add by Xiao for GST refer to bug#10043656.
1674: FROM jai_mtl_trxs /* jai_mtl_trxs_temp is modified as jai_mtl_trxs by Vijay for ReArch. bug#2942973 */
1675: WHERE transaction_temp_id = p_line_id;
1676:
1677: CURSOR Fetch_Exempt_Cur( AddressId IN NUMBER ) IS -- OE Side
1678: SELECT NVL( Exempt, 'N' )