APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_INVOICE_LINES_ALL

Line 39: ap_invoice_lines_all L

35: debug_info := 'Are Original Invoices Valid';
36: SELECT count(*)
37: INTO l_count
38: FROM ap_invoice_lines_interface IL,
39: ap_invoice_lines_all L
40: WHERE IL.invoice_id = p_instruction_id
41: AND IL.po_line_location_id = L.po_line_location_id
42: AND L.org_id = p_org_id
43: AND L.match_type IN ('ITEM_TO_PO', 'ITEM_TO_RECEIPT',

Line 119: ap_invoice_lines_all L

115: debug_info := 'Are Holds OK';
116: SELECT count(*)
117: INTO l_count
118: FROM ap_invoice_lines_interface IL,
119: ap_invoice_lines_all L
120: WHERE IL.invoice_id = p_instruction_id
121: AND L.org_id = p_org_id
122: AND L.po_line_location_id = IL.po_line_location_id
123: AND L.match_type IN ('ITEM_TO_PO', 'ITEM_TO_RECEIPT',

Line 277: FROM ap_invoice_lines_all

273: --
274: debug_info := 'IF ppa_already_Exists';
275: SELECT count(*)
276: INTO l_count
277: FROM ap_invoice_lines_all
278: WHERE corrected_inv_id = p_invoice_id
279: AND corrected_line_number = p_line_number
280: AND line_type_lookup_code IN ('RETROITEM')
281: AND match_type = 'PO_PRICE_ADJUSTMENT';

Line 293: FROM ap_invoice_lines_all

289: FROM ap_invoices_all AI
290: WHERE invoice_type_lookup_code = 'PO PRICE ADJUST'
291: AND source = 'PPA'
292: AND ai.invoice_id = (SELECT MAX(invoice_id)
293: FROM ap_invoice_lines_all
294: WHERE corrected_inv_id = p_invoice_id
295: AND corrected_line_number = p_line_number
296: AND line_type_lookup_code IN ('RETROITEM')
297: AND match_type = 'PO_PRICE_ADJUSTMENT'

Line 466: FROM ap_invoice_lines_all

462: BEGIN
463: debug_info := 'IF Adj Corr Exists';
464: SELECT count(*)
465: INTO l_count
466: FROM ap_invoice_lines_all
467: WHERE invoice_id = p_invoice_id
468: AND corrected_inv_id = p_invoice_id
469: AND corrected_line_number = p_line_number
470: AND line_type_lookup_code IN ('RETROITEM')

Line 670: FROM ap_invoice_lines_all

666: PRODUCT_TABLE,
667: REFERENCE_KEY1,
668: REFERENCE_KEY2,
669: RCV_SHIPMENT_LINE_ID
670: FROM ap_invoice_lines_all
671: WHERE corrected_inv_id = p_invoice_id
672: AND corrected_line_number = p_line_number
673: AND discarded_flag <> 'Y'
674: AND cancelled_flag <> 'Y'

Line 1150: l_line_type_lookup_code AP_INVOICE_LINES_ALL.line_type_lookup_code%TYPE;

1146: FUNCTION Get_Dist_Type_lookup_code(
1147: p_invoice_distribution_id IN NUMBER)
1148: RETURN VARCHAR2 IS
1149:
1150: l_line_type_lookup_code AP_INVOICE_LINES_ALL.line_type_lookup_code%TYPE;
1151: debug_info VARCHAR2(1000);
1152:
1153: BEGIN
1154: debug_info := 'Get Dist_Type_lookup_code';

Line 2127: FROM ap_invoice_lines_all L

2123: INTO l_existing_ppa_count
2124: FROM ap_invoices_all I
2125: WHERE I.source = 'PPA'
2126: AND EXISTS (SELECT invoice_id
2127: FROM ap_invoice_lines_all L
2128: WHERE L.invoice_id = I.invoice_id
2129: AND L.corrected_inv_id = p_invoice_id
2130: AND L.corrected_line_number = p_line_number
2131: AND L.match_type = 'PO_PRICE_ADJUSTMENT');