APPS.POS_AP_INVOICES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 329: from ap_invoice_lines_all al,

325: ---cursor
326: cursor receipt_info_cursor is
327: --using lines for matching
328: select distinct rsh.receipt_num, rsh.SHIPMENT_HEADER_ID
329: from ap_invoice_lines_all al,
330: rcv_transactions rt,
331: rcv_shipment_headers rsh
332: where al.invoice_id = l_invoice_id
333: and al.rcv_transaction_id = rt.transaction_id

Line 402: from ap_invoice_lines_all ail,

398: -- Declare cursor to retrieve po_numbers, header id's and release id's
399: CURSOR po_info_cursor IS
400: --using invoice lines
401: select distinct ph.clm_document_number, ph.po_header_id, null
402: from ap_invoice_lines_all ail,
403: po_headers_all ph
404: where ail.invoice_id = l_invoice_id and
405: ail.po_release_id is null and
406: ph.po_header_id = ail.po_header_id and

Line 410: from ap_invoice_lines_all ail,

406: ph.po_header_id = ail.po_header_id and
407: ph.type_lookup_code = 'STANDARD'
408: union all
409: select distinct (ph.clm_document_number||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
410: from ap_invoice_lines_all ail,
411: po_headers_all ph,
412: po_releases_all pr
413: WHERE ail.invoice_id = l_invoice_id and
414: pr.po_release_id = ail.po_release_id and

Line 508: from ap_invoice_lines_All

504: BEGIN
505:
506: select nvl(sum(amount),0)
507: INTO retainage_amount1
508: from ap_invoice_lines_All
509: where invoice_id = l_invoice_id
510: and LINE_TYPE_LOOKUP_CODE = 'RETAINAGE RELEASE';
511:
512: SELECT nvl(sum(amount),0)

Line 518: (SELECT 'X' FROM ap_invoice_lines_all ail

514: FROM ap_invoice_distributions_all aid
515: WHERE aid.invoice_id = l_invoice_id
516: AND aid.line_type_lookup_code = 'RETAINAGE'
517: AND EXISTS
518: (SELECT 'X' FROM ap_invoice_lines_all ail
519: WHERE ail.invoice_id = l_invoice_id
520: AND ail.line_number = aid.invoice_line_number
521: AND ail.line_type_lookup_code <> 'RETAINAGE RELEASE'
522: );

Line 542: from ap_invoice_lines_All

538: BEGIN
539:
540: select nvl(sum(amount),0)
541: INTO prepay_amount1
542: from ap_invoice_lines_All
543: where invoice_id = l_invoice_id
544: and LINE_TYPE_LOOKUP_CODE = 'PREPAY';
545:
546: SELECT nvl(sum(amount),0)

Line 552: (SELECT 'X' FROM ap_invoice_lines_all ail

548: FROM ap_invoice_distributions_all aid
549: WHERE aid.invoice_id = l_invoice_id
550: AND aid.line_type_lookup_code = 'PREPAY'
551: AND EXISTS
552: (SELECT 'X' FROM ap_invoice_lines_all ail
553: WHERE ail.invoice_id = l_invoice_id
554: AND ail.line_number = aid.invoice_line_number
555: AND ail.line_type_lookup_code <> 'PREPAY'
556: );

Line 575: from ap_invoice_lines_All

571: BEGIN
572:
573: select nvl(sum(amount),0)
574: INTO amount1
575: from ap_invoice_lines_All
576: where invoice_id = l_invoice_id
577: and LINE_TYPE_LOOKUP_CODE = 'TAX' ;
578:
579: return(amount1);

Line 598: from ap_invoice_lines_All

594: BEGIN
595:
596: select nvl(sum(amount),0)
597: INTO amount1
598: from ap_invoice_lines_All
599: where invoice_id = l_invoice_id;
600:
601: SELECT nvl(sum(amount),0)
602: INTO retainage_amount2

Line 607: (SELECT 'X' FROM ap_invoice_lines_all ail

603: FROM ap_invoice_distributions_all aid
604: WHERE aid.invoice_id = l_invoice_id
605: AND aid.line_type_lookup_code = 'RETAINAGE'
606: AND EXISTS
607: (SELECT 'X' FROM ap_invoice_lines_all ail
608: WHERE ail.invoice_id = l_invoice_id
609: AND ail.line_number = aid.invoice_line_number
610: AND ail.line_type_lookup_code <> 'RETAINAGE RELEASE'
611: );

Line 619: (SELECT 'X' FROM ap_invoice_lines_all ail

615: FROM ap_invoice_distributions_all aid
616: WHERE aid.invoice_id = l_invoice_id
617: AND aid.line_type_lookup_code = 'PREPAY'
618: AND EXISTS
619: (SELECT 'X' FROM ap_invoice_lines_all ail
620: WHERE ail.invoice_id = l_invoice_id
621: AND ail.line_number = aid.invoice_line_number
622: AND ail.line_type_lookup_code <> 'PREPAY'
623: );