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 281: FROM ap_invoice_lines_all

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

Line 297: FROM ap_invoice_lines_all

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

Line 470: FROM ap_invoice_lines_all

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

Line 674: FROM ap_invoice_lines_all

670: PRODUCT_TABLE,
671: REFERENCE_KEY1,
672: REFERENCE_KEY2,
673: RCV_SHIPMENT_LINE_ID
674: FROM ap_invoice_lines_all
675: WHERE corrected_inv_id = p_invoice_id
676: AND corrected_line_number = p_line_number
677: AND discarded_flag <> 'Y'
678: AND cancelled_flag <> 'Y'

Line 1157: l_line_type_lookup_code AP_INVOICE_LINES_ALL.line_type_lookup_code%TYPE;

1153: FUNCTION Get_Dist_Type_lookup_code(
1154: p_invoice_distribution_id IN NUMBER)
1155: RETURN VARCHAR2 IS
1156:
1157: l_line_type_lookup_code AP_INVOICE_LINES_ALL.line_type_lookup_code%TYPE;
1158: debug_info VARCHAR2(1000);
1159:
1160: BEGIN
1161: debug_info := 'Get Dist_Type_lookup_code';

Line 2164: FROM ap_invoice_lines_all L

2160: INTO l_existing_ppa_count
2161: FROM ap_invoices_all I
2162: WHERE I.source = 'PPA'
2163: AND EXISTS (SELECT invoice_id
2164: FROM ap_invoice_lines_all L
2165: WHERE L.invoice_id = I.invoice_id
2166: AND L.corrected_inv_id = p_invoice_id
2167: --Commented below condition for bug#9855094
2168: --AND L.corrected_line_number = p_line_number