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.segment1
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.segment1||'-'||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 336: FROM ap_invoice_distributions_all aid,

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

Line 418: FROM ap_invoice_distributions_all aid,

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

Line 427: FROM ap_invoice_distributions_all aid,

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

Line 483: from ap_invoice_distributions_all --ap_invoice_distributions

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

Line 512: FROM ap_invoice_distributions_all aid

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

Line 546: FROM ap_invoice_distributions_all aid

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

Line 601: FROM ap_invoice_distributions_all aid

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

Line 613: FROM ap_invoice_distributions_all aid

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