APPS.POS_TOTALS_PO_SV dependencies on PO_LINES_ARCHIVE_ALL

Line 65: FROM po_lines_archive_all pol

61: (POL.QUANTITY * POL.UNIT_PRICE )))
62: / x_min_unit )
63: * x_min_unit ), 0)
64: into x_po_total
65: FROM po_lines_archive_all pol
66: WHERE pol.from_header_id = X_header_id
67: AND pol.latest_external_Flag = 'Y';
68: else
69: /* Bug 12997708 */

Line 73: FROM po_lines_archive_all pol

69: /* Bug 12997708 */
70: SELECT Nvl(sum (decode(pol.quantity, null, pol.amount,
71: (POL.QUANTITY * POL.UNIT_PRICE ))),0)
72: into x_po_total
73: FROM po_lines_archive_all pol
74: WHERE pol.from_header_id = X_header_id
75: AND pol.latest_external_Flag = 'Y';
76: end if;
77: ELSE

Line 340: FROM po_lines_archive_all plaa1

336: (plaa1.quantity
337: * nvl(plaa1.unit_price,0)))
338: ,x_precision)
339: INTO X_po_total
340: FROM po_lines_archive_all plaa1
341: where plaa1.po_line_id = x_po_line_id
342: and revision_num = (
343: SELECT max(plaa2.revision_num)
344: FROM po_lines_archive_all plaa2

Line 344: FROM po_lines_archive_all plaa2

340: FROM po_lines_archive_all plaa1
341: where plaa1.po_line_id = x_po_line_id
342: and revision_num = (
343: SELECT max(plaa2.revision_num)
344: FROM po_lines_archive_all plaa2
345: WHERE plaa2.revision_num <= x_revision_num
346: AND plaa2.po_line_id = plaa1.po_line_id );
347: else
348: select round(

Line 357: FROM po_lines_archive_all plaa1

353: * nvl(plaa1.unit_price,0)
354: )
355: )/x_min_unit)*x_min_unit
356: INTO X_po_total
357: FROM po_lines_archive_all plaa1
358: WHERE plaa1.po_line_id = x_po_line_id
359: AND revision_num = (
360: SELECT max( plaa2.revision_num )
361: FROM po_lines_archive_all plaa2

Line 361: FROM po_lines_archive_all plaa2

357: FROM po_lines_archive_all plaa1
358: WHERE plaa1.po_line_id = x_po_line_id
359: AND revision_num = (
360: SELECT max( plaa2.revision_num )
361: FROM po_lines_archive_all plaa2
362: WHERE plaa2.revision_num <= x_revision_num
363: AND plaa2.po_line_id = plaa1.po_line_id ) ;
364: end if;
365: