DBA Data[Home] [Help]

APPS.POS_AP_INVOICES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 327: from ap_invoice_lines_all al,

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

Line 400: from ap_invoice_lines_all ail,

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

Line 408: from ap_invoice_lines_all ail,

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

Line 506: from ap_invoice_lines_All

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

Line 516: (SELECT 'X' FROM ap_invoice_lines_all ail

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

Line 540: from ap_invoice_lines_All

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

Line 550: (SELECT 'X' FROM ap_invoice_lines_all ail

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

Line 573: from ap_invoice_lines_All

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

Line 596: from ap_invoice_lines_All

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

Line 605: (SELECT 'X' FROM ap_invoice_lines_all ail

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

Line 617: (SELECT 'X' FROM ap_invoice_lines_all ail

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