DBA Data[Home] [Help]

APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on AP_INVOICE_LINES

Line 795: , P_Inv_Line_Num ap_invoice_lines_all.line_number%TYPE

791: --
792:
793: PROCEDURE Supp_Wh_Def
794: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
795: , P_Inv_Line_Num ap_invoice_lines_all.line_number%TYPE
796: , P_Inv_Dist_Id ap_invoice_distributions_all.invoice_distribution_id%TYPE
797: , P_Calling_Module VARCHAR2
798: , P_Parent_Dist_ID IN Number Default null
799: ) IS

Line 1015: AP_Invoice_Lines apil

1011: INTO v_tax_payer_id,
1012: v_ship_to_loc,
1013: v_line_type
1014: FROM AP_Invoice_Distributions apid,
1015: AP_Invoice_Lines apil
1016: WHERE apid.invoice_id = p_invoice_id
1017: AND apid.invoice_distribution_id = p_inv_dist_id
1018: AND apid.invoice_line_number = apil.line_number
1019: AND apid.invoice_id = apil.invoice_id;

Line 1055: AP_Invoice_Lines apil

1051: INTO v_tax_payer_id,
1052: v_ship_to_loc,
1053: v_line_type
1054: FROM AP_Invoice_Distributions apid,
1055: AP_Invoice_Lines apil
1056: WHERE apid.invoice_id = P_Invoice_Id
1057: AND apid.invoice_distribution_id = db_reg.invoice_distribution_id
1058: AND apid.invoice_line_number = apil.line_number
1059: AND apid.invoice_id = apil.invoice_id;

Line 1338: AP_Invoice_Lines apil

1334: INTO v_tax_payer_id,
1335: v_ship_to_loc,
1336: v_line_type
1337: FROM AP_Invoice_Distributions apid,
1338: AP_Invoice_Lines apil
1339: WHERE apid.invoice_id = P_Invoice_Id
1340: AND apid.invoice_distribution_id = db_reg.invoice_distribution_id
1341: AND apil.line_number = apid.invoice_line_number
1342: AND apid.invoice_id = apil.invoice_id;