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_TOTALS_PO_SV dependencies on STANDARD

Line 142: if (X_doc_type in ('STANDARD')) then

138: BEGIN
139:
140: --togeorge 11/15/2000
141: --changed org specific views to _all tables
142: if (X_doc_type in ('STANDARD')) then
143:
144: select org_id
145: into x_org_id
146: from po_headers_all

Line 406: and shipment_type in ('STANDARD','PLANNED')

402: * nvl(plla1.price_override,0))),x_precision)),0)
403: INTO X_po_total
404: FROM po_line_locations_archive_all plla1
405: where plla1.po_line_id = x_po_line_id
406: and shipment_type in ('STANDARD','PLANNED')
407: and revision_num = (
408: SELECT max(plla2.revision_num)
409: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
410: WHERE plla2.revision_num <= x_revision_num

Line 422: AND shipment_type in ('STANDARD','PLANNED')

418: * nvl(plla1.price_override,0)))/x_min_unit)*x_min_unit),0)
419: INTO X_po_total
420: FROM po_line_locations_archive_all plla1
421: WHERE plla1.po_line_id = x_po_line_id
422: AND shipment_type in ('STANDARD','PLANNED')
423: AND revision_num = (
424: SELECT max( plla2.revision_num )
425: FROM po_line_locations_archive_all plla2
426: WHERE plla2.revision_num <= x_revision_num