APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 39: ap_invoice_distributions aid

35: ,ai.global_attribute13 dgi_type
36: ,SUM(DECODE(ai.invoice_currency_code, 'ARS', aid.amount, aid.base_amount)) invoice_amt
37: FROM ap_invoices ai,
38: ap_invoice_lines ail,
39: ap_invoice_distributions aid
40: WHERE ai.vendor_id = p_supplier_id
41: AND ai.invoice_id = aid.invoice_id
42: AND ai.invoice_id = ail.invoice_id
43: AND ail.line_number = aid.invoice_line_number

Line 229: ap_invoice_distributions aid

225: INTO v_inv_amt,
226: v_inv_tax_amt
227: FROM ap_invoices ai,
228: ap_invoice_lines ail,
229: ap_invoice_distributions aid
230: WHERE ai.invoice_id = AID.invoice_id
231: AND ai.invoice_id = ail.invoice_id
232: AND ail.line_number = aid.invoice_line_number
233: AND ai.invoice_id = c_supp_inv(inv_rec).invoice_id

Line 676: FROM ap_invoice_distributions

672: --, P_Defaulting_flag BOOLEAN
673: ) IS
674: CURSOR Invoice_Distrib IS
675: SELECT invoice_distribution_id
676: FROM ap_invoice_distributions
677: WHERE invoice_id = P_Invoice_ID;
678: -- The following variables are used to get the information from the invoice
679: -- ditribution lines.
680: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;

Line 680: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;

676: FROM ap_invoice_distributions
677: WHERE invoice_id = P_Invoice_ID;
678: -- The following variables are used to get the information from the invoice
679: -- ditribution lines.
680: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
681: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
682: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
683:
684: BEGIN

Line 681: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;

677: WHERE invoice_id = P_Invoice_ID;
678: -- The following variables are used to get the information from the invoice
679: -- ditribution lines.
680: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
681: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
682: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
683:
684: BEGIN
685:

Line 682: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;

678: -- The following variables are used to get the information from the invoice
679: -- ditribution lines.
680: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
681: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
682: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
683:
684: BEGIN
685:
686: IF p_debug_log = 'Y' THEN

Line 700: FROM AP_Invoice_Distributions apid,

696: ,apid.line_type_lookup_code -- Line Type
697: INTO v_tax_payer_id,
698: v_ship_to_loc,
699: v_line_type
700: FROM AP_Invoice_Distributions apid,
701: AP_Invoice_Lines apil
702: WHERE apid.invoice_id = P_Invoice_Id
703: AND apid.invoice_distribution_id = db_reg.invoice_distribution_id
704: AND apil.line_number = apid.invoice_line_number

Line 726: p_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE,

722:
723: PROCEDURE Monotrib_Wh_Def_Line
724: ( p_invoice_id NUMBER,
725: p_inv_dist_id NUMBER,
726: p_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE,
727: p_ship_to_loc VARCHAR2,
728: p_line_type VARCHAR2,
729: p_vendor_id NUMBER
730: ) IS