eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_AP_INVOICES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 24: FROM ap_invoice_distributions_all aid,

20: --togeorge 11/15/2000
21: --changed org specific views to _all tables
22: CURSOR po_number_cursor IS
23: SELECT DISTINCT ph.clm_document_number
24: FROM ap_invoice_distributions_all aid,
25: po_distributions_all pd,
26: po_headers_all ph
27: WHERE aid.invoice_id = l_invoice_id
28: AND aid.po_distribution_id = pd.po_distribution_id

Line 33: FROM ap_invoice_distributions_all aid,

29: AND pd.po_header_id = ph.po_header_id
30: AND ph.type_lookup_code = 'STANDARD'
31: UNION ALL
32: SELECT DISTINCT (ph.clm_document_number||'-'||pr.release_num)
33: FROM ap_invoice_distributions_all aid,
34: po_distributions_all pd,
35: po_headers_all ph,
36: po_releases_all pr
37: WHERE aid.invoice_id = l_invoice_id

Line 84: FROM ap_invoice_distributions_all aid,

80: ---------------------------------------------------------------------
81:
82: CURSOR packing_slip_cursor IS
83: select DISTINCT RSH.PACKING_SLIP packing_slip
84: FROM ap_invoice_distributions_all aid,
85: po_distributions_all pd,
86: rcv_shipment_headers rsh,
87: rcv_shipment_lines rsl
88: WHERE aid.invoice_id = l_invoice_id

Line 95: FROM ap_invoice_distributions_all aid,

91: AND rsl.shipment_header_id = rsh.shipment_header_id
92: AND rsh.packing_slip is not null
93: union
94: select DISTINCT RSL.PACKING_SLIP packing_slip
95: FROM ap_invoice_distributions_all aid,
96: po_distributions_all pd,
97: rcv_shipment_headers rsh,
98: rcv_shipment_lines rsl
99: WHERE aid.invoice_id = l_invoice_id

Line 146: FROM ap_invoice_distributions_all aid,

142: ---------------------------------------------------------------------
143:
144: CURSOR packing_slip_cursor IS
145: select DISTINCT RSH.PACKING_SLIP packing_slip
146: FROM ap_invoice_distributions_all aid,
147: po_distributions_all pd,
148: rcv_shipment_headers rsh,
149: rcv_shipment_lines rsl
150: WHERE aid.invoice_id = l_invoice_id

Line 157: FROM ap_invoice_distributions_all aid,

153: AND rsl.shipment_header_id = rsh.shipment_header_id
154: AND rsh.packing_slip is not null
155: union
156: select DISTINCT RSL.PACKING_SLIP packing_slip
157: FROM ap_invoice_distributions_all aid,
158: po_distributions_all pd,
159: rcv_shipment_headers rsh,
160: rcv_shipment_lines rsl
161: WHERE aid.invoice_id = l_invoice_id

Line 338: FROM ap_invoice_distributions_all aid,

334: and rt.SHIPMENT_HEADER_ID = rsh.SHIPMENT_HEADER_ID;
335:
336: --using distributions for matching
337: /* SELECT distinct rsh.SHIPMENT_HEADER_ID, rsh.receipt_num
338: FROM ap_invoice_distributions_all aid,
339: rcv_transactions rt,
340: rcv_shipment_headers rsh
341: WHERE aid.invoice_id = l_invoice_id
342: and aid.rcv_transaction_id = rt.transaction_id

Line 420: FROM ap_invoice_distributions_all aid,

416: ph.type_lookup_code = 'BLANKET' ;
417:
418: --using invoice distributions
419: /* SELECT DISTINCT ph.segment1,ph.po_header_id,null
420: FROM ap_invoice_distributions_all aid,
421: po_distributions_all pd,
422: po_headers_all ph
423: WHERE aid.invoice_id = l_invoice_id
424: AND aid.po_distribution_id = pd.po_distribution_id

Line 429: FROM ap_invoice_distributions_all aid,

425: AND pd.po_header_id = ph.po_header_id
426: AND ph.type_lookup_code = 'STANDARD'
427: UNION ALL
428: SELECT DISTINCT (ph.segment1||'-'||pr.release_num),ph.po_header_id, pr.po_release_id
429: FROM ap_invoice_distributions_all aid,
430: po_distributions_all pd,
431: po_headers_all ph,
432: po_releases_all pr
433: WHERE aid.invoice_id = l_invoice_id

Line 485: from ap_invoice_distributions_all --ap_invoice_distributions

481: --togeorge 11/15/2000
482: --changed org specific views to _all tables
483: select (0 - sum(nvl(amount,0)))
484: into amount_withheld
485: from ap_invoice_distributions_all --ap_invoice_distributions
486: where invoice_id = l_invoice_id
487: and line_type_lookup_code = 'AWT';
488:
489: return(amount_withheld);

Line 514: FROM ap_invoice_distributions_all aid

510: and LINE_TYPE_LOOKUP_CODE = 'RETAINAGE RELEASE';
511:
512: SELECT nvl(sum(amount),0)
513: INTO retainage_amount2
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

Line 548: FROM ap_invoice_distributions_all aid

544: and LINE_TYPE_LOOKUP_CODE = 'PREPAY';
545:
546: SELECT nvl(sum(amount),0)
547: INTO prepay_amount2
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

Line 603: FROM ap_invoice_distributions_all aid

599: where invoice_id = l_invoice_id;
600:
601: SELECT nvl(sum(amount),0)
602: INTO retainage_amount2
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

Line 615: FROM ap_invoice_distributions_all aid

611: );
612:
613: SELECT nvl(sum(amount),0)
614: INTO prepay_amount2
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