APPS.POS_TOTALS_PO_SV dependencies on STANDARD

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

159: BEGIN
160:
161: --togeorge 11/15/2000
162: --changed org specific views to _all tables
163: if (X_doc_type in ('STANDARD')) then
164:
165: select org_id
166: into x_org_id
167: from po_headers_all

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

423: * nvl(plla1.price_override,0))),x_precision))
424: INTO X_po_total
425: FROM po_line_locations_archive_all plla1
426: where plla1.po_line_id = x_po_line_id
427: and shipment_type in ('STANDARD','PLANNED')
428: and revision_num = (
429: SELECT max(plla2.revision_num)
430: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
431: WHERE plla2.revision_num <= x_revision_num

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

439: * nvl(plla1.price_override,0)))/x_min_unit)*x_min_unit)
440: INTO X_po_total
441: FROM po_line_locations_archive_all plla1
442: WHERE plla1.po_line_id = x_po_line_id
443: AND shipment_type in ('STANDARD','PLANNED')
444: AND revision_num = (
445: SELECT max( plla2.revision_num )
446: FROM po_line_locations_archive_all plla2
447: WHERE plla2.revision_num <= x_revision_num