APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_AP_INVOICE_LINES

Line 859: , jai_ap_invoice_lines jasl

855: FROM
856: ap_invoices_all apa
857: , ap_invoice_lines_all apla
858: , po_vendors pov
859: , jai_ap_invoice_lines jasl
860: WHERE apa.invoice_id = p_document_id
861: AND apa.invoice_id = apla.invoice_id
862: AND apla.line_number = p_document_line_id
863: AND jasl.invoice_id = apa.invoice_id

Line 1022: jai_ap_invoice_lines jasl

1018: SELECT
1019: jasl.service_type_code
1020: , SUM (jcdt.tax_amt)
1021: FROM
1022: jai_ap_invoice_lines jasl
1023: , jai_cmn_document_taxes jcdt
1024: , jai_cmn_taxes_all jcta
1025: WHERE jasl.invoice_id = jcdt.source_doc_id
1026: AND jasl.invoice_line_number = jcdt.source_doc_line_id

Line 1043: jai_ap_invoice_lines jasl

1039: IS
1040: SELECT
1041: SUM (jcdt.tax_amt)
1042: FROM
1043: jai_ap_invoice_lines jasl
1044: , jai_cmn_document_taxes jcdt
1045: , jai_cmn_taxes_all jcta
1046: WHERE jasl.invoice_id = p_document_id
1047: AND jasl.parent_invoice_line_number = lp_line_id

Line 1060: jai_ap_invoice_lines jasl

1056: ( lp_line_id jai_cmn_document_taxes.source_doc_line_id%TYPE) IS
1057: SELECT
1058: jasl.service_type_code
1059: FROM
1060: jai_ap_invoice_lines jasl
1061: WHERE invoice_id = p_document_id
1062: AND invoice_line_number = lp_line_id
1063: ;
1064: --------------------------------------------------------------------------

Line 1807: update JAI_AP_INVOICE_LINES set service_type_code = rec.service_type_code

1803: --Added by Lion for bug#6911533 on 2008/04/22
1804: -------------------------------------------------------------------------
1805: elsif rec.transaction_source = jai_constants.G_AP_STANDALONE_INVOICE then
1806:
1807: update JAI_AP_INVOICE_LINES set service_type_code = rec.service_type_code
1808: , last_update_date = sysdate
1809: , last_updated_by = lv_user_id
1810: , last_update_login = lv_login_id
1811: where invoice_id = rec.document_id

Line 1956: ( lp_invoice_id jai_ap_invoice_lines.invoice_id%TYPE

1952:
1953: -- Added by Bill Shi for standalone invoice on 2007/09/27
1954: --------------------------------------------------------------------------
1955: CURSOR l_get_si_reference_csr
1956: ( lp_invoice_id jai_ap_invoice_lines.invoice_id%TYPE
1957: , lp_invoice_line_number jai_ap_invoice_lines.invoice_line_number%TYPE
1958: ) IS
1959: SELECT
1960: jail.invoice_id

Line 1957: , lp_invoice_line_number jai_ap_invoice_lines.invoice_line_number%TYPE

1953: -- Added by Bill Shi for standalone invoice on 2007/09/27
1954: --------------------------------------------------------------------------
1955: CURSOR l_get_si_reference_csr
1956: ( lp_invoice_id jai_ap_invoice_lines.invoice_id%TYPE
1957: , lp_invoice_line_number jai_ap_invoice_lines.invoice_line_number%TYPE
1958: ) IS
1959: SELECT
1960: jail.invoice_id
1961: , jail.invoice_line_number

Line 1963: jai_ap_invoice_lines jail

1959: SELECT
1960: jail.invoice_id
1961: , jail.invoice_line_number
1962: FROM
1963: jai_ap_invoice_lines jail
1964: , ap_invoice_distributions_all aida
1965: WHERE jail.invoice_id = aida.invoice_id
1966: AND jail.invoice_line_number = aida.invoice_line_number
1967: AND jail.invoice_id = lp_invoice_id