APPS.POS_TOTALS_PO_SV dependencies on PO_LINES_ARCHIVE_ALL

Line 71: po_lines_archive_all pol

67: * x_min_unit )
68: into x_po_total
69: FROM po_distributions_archive_all pod,
70: po_line_locations_archive_all poll,
71: po_lines_archive_all pol
72: WHERE pod.line_location_id = poll.line_location_id
73: AND poll.po_line_id = pol.po_line_id
74: AND pol.from_header_id = X_header_id
75: AND poll.latest_external_flag ='Y'

Line 88: po_lines_archive_all pol

84: * poll.price_override)))
85: into x_po_total
86: FROM po_distributions_archive_all pod,
87: po_line_locations_archive_all poll,
88: po_lines_archive_all pol
89: WHERE pod.line_location_id = poll.line_location_id
90: AND poll.po_line_id = pol.po_line_id
91: AND pol.from_header_id = X_header_id
92: AND poll.latest_external_flag ='Y'

Line 361: FROM po_lines_archive_all plaa1

357: (plaa1.quantity
358: * nvl(plaa1.unit_price,0)))
359: ,x_precision)
360: INTO X_po_total
361: FROM po_lines_archive_all plaa1
362: where plaa1.po_line_id = x_po_line_id
363: and revision_num = (
364: SELECT max(plaa2.revision_num)
365: FROM po_lines_archive_all plaa2

Line 365: FROM po_lines_archive_all plaa2

361: FROM po_lines_archive_all plaa1
362: where plaa1.po_line_id = x_po_line_id
363: and revision_num = (
364: SELECT max(plaa2.revision_num)
365: FROM po_lines_archive_all plaa2
366: WHERE plaa2.revision_num <= x_revision_num
367: AND plaa2.po_line_id = plaa1.po_line_id );
368: else
369: select round(

Line 378: FROM po_lines_archive_all plaa1

374: * nvl(plaa1.unit_price,0)
375: )
376: )/x_min_unit)*x_min_unit
377: INTO X_po_total
378: FROM po_lines_archive_all plaa1
379: WHERE plaa1.po_line_id = x_po_line_id
380: AND revision_num = (
381: SELECT max( plaa2.revision_num )
382: FROM po_lines_archive_all plaa2

Line 382: FROM po_lines_archive_all plaa2

378: FROM po_lines_archive_all plaa1
379: WHERE plaa1.po_line_id = x_po_line_id
380: AND revision_num = (
381: SELECT max( plaa2.revision_num )
382: FROM po_lines_archive_all plaa2
383: WHERE plaa2.revision_num <= x_revision_num
384: AND plaa2.po_line_id = plaa1.po_line_id ) ;
385: end if;
386: