[Home] [Help]
1788: ,jasl.location_id location_id
1789: from ap_invoices_all apa
1790: , ap_invoice_lines_all apla
1791: , po_vendors pov
1792: , jai_ap_invoice_lines jasl
1793: where
1794: apa.invoice_id = p_document_id
1795: and apa.invoice_id = apla.invoice_id
1796: and apla.line_number = p_document_line_id
1817: --Added by Qiong for bug#13405553 end
1818:
1819: CURSOR c_get_standalone_org_loc IS
1820: SELECT organization_id, location_id
1821: FROM JAI_AP_INVOICE_LINES
1822: where invoice_id = p_document_id
1823: --Add by Xiao for fixing bug#10634960, begin
1824: --------------------------------------------------------------------
1825: AND invoice_line_number = (SELECT parent_invoice_line_number
1822: where invoice_id = p_document_id
1823: --Add by Xiao for fixing bug#10634960, begin
1824: --------------------------------------------------------------------
1825: AND invoice_line_number = (SELECT parent_invoice_line_number
1826: FROM JAI_AP_INVOICE_LINES jail
1827: WHERE jail.invoice_line_number = p_document_line_id
1828: AND jail.invoice_id = p_document_id)
1829: --------------------------------------------------------------------
1830: --Add by Xiao for fixing bug#10634960, end
1831: and PARENT_INVOICE_LINE_NUMBER is NULL;
1832:
1833: CURSOR c_get_standalone_inv_line_tax (cp_invoice_id jai_cmn_document_taxes.source_doc_id%type, cp_line_id jai_cmn_document_taxes.source_doc_line_id%type) IS
1834: Select service_type_code,sum(jcdt.tax_amt)
1835: from jai_ap_invoice_lines jasl,
1836: jai_cmn_document_taxes jcdt,
1837: jai_cmn_taxes_all jcta
1838: where source_doc_line_id = cp_line_id
1839: AND jcdt.source_doc_id = cp_invoice_id
1900:
1901: CURSOR c_get_service_type
1902: IS
1903: SELECT service_type_code
1904: FROM jai_ap_invoice_lines
1905: WHERE invoice_id = p_document_id
1906: AND invoice_line_number = p_document_line_id;
1907: /*Added by Wenqiong for Advanced Receipts Begin*/
1908: cursor c_get_rcpt_trx_details