APPS.JAI_OPEN_API_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1111: FROM ap_invoice_distributions_all

1107: CURSOR chk_ap_accted
1108: IS
1109: SELECT
1110: COUNT(1)
1111: FROM ap_invoice_distributions_all
1112: WHERE INVOICE_ID = pn_trx_id
1113: AND INVOICE_LINE_NUMBER = pn_trx_line_id
1114: AND distribution_line_number = 1
1115: AND NVL(POSTED_FLAG,'N') = 'Y'

Line 11987: --Update columns in ap_invoice_distributions_all, then distribution lines

11983: amount_remaining = ln_total_amount,
11984: inv_curr_gross_amount = ln_total_amount
11985: WHERE invoice_id = rec_trx_id.trx_id;
11986:
11987: --Update columns in ap_invoice_distributions_all, then distribution lines
11988: --can be pickep up be create accounting programs.
11989: UPDATE ap_invoice_distributions_all
11990: SET accounting_event_id = (SELECT accounting_event_id
11991: FROM ap_invoice_distributions_all

Line 11989: UPDATE ap_invoice_distributions_all

11985: WHERE invoice_id = rec_trx_id.trx_id;
11986:
11987: --Update columns in ap_invoice_distributions_all, then distribution lines
11988: --can be pickep up be create accounting programs.
11989: UPDATE ap_invoice_distributions_all
11990: SET accounting_event_id = (SELECT accounting_event_id
11991: FROM ap_invoice_distributions_all
11992: WHERE invoice_id = rec_trx_id.trx_id
11993: AND line_type_lookup_code = 'ITEM'

Line 11991: FROM ap_invoice_distributions_all

11987: --Update columns in ap_invoice_distributions_all, then distribution lines
11988: --can be pickep up be create accounting programs.
11989: UPDATE ap_invoice_distributions_all
11990: SET accounting_event_id = (SELECT accounting_event_id
11991: FROM ap_invoice_distributions_all
11992: WHERE invoice_id = rec_trx_id.trx_id
11993: AND line_type_lookup_code = 'ITEM'
11994: AND rownum = 1),
11995: total_dist_amount = amount,