DBA Data[Home] [Help]

APPS.PO_CHORD_WF2 dependencies on PO_LINES_ARCHIVE_ALL

Line 116: PO_LINES_ARCHIVE_ALL POLA

112: -- SQL Join: po_line_id, line_num
113: SELECT DISTINCT 'Y'
114: INTO x_lines_control.line_num
115: FROM PO_LINES POL,
116: PO_LINES_ARCHIVE_ALL POLA
117: WHERE POL.po_header_id = x_po_header_id
118: AND POL.po_line_id = POLA.po_line_id (+)
119: AND POLA.latest_external_flag (+) = 'Y'
120: AND (

Line 140: PO_LINES_ARCHIVE_ALL POLA

136: -- SQL Join: po_line_id, item_id
137: SELECT DISTINCT 'Y'
138: INTO x_lines_control.item_id
139: FROM PO_LINES_ALL POL,
140: PO_LINES_ARCHIVE_ALL POLA
141: WHERE POL.po_header_id = x_po_header_id
142: AND POL.po_line_id = POLA.po_line_id (+)
143: AND POLA.latest_external_flag (+) = 'Y'
144: AND (

Line 163: PO_LINES_ARCHIVE_ALL POLA

159: -- SQL Join: po_line_id, item_revision
160: SELECT DISTINCT 'Y'
161: INTO x_lines_control.item_revision
162: FROM PO_LINES_ALL POL,
163: PO_LINES_ARCHIVE_ALL POLA
164: WHERE POL.po_header_id = x_po_header_id
165: AND POL.po_line_id = POLA.po_line_id (+)
166: AND POLA.latest_external_flag (+) = 'Y'
167: AND (

Line 186: PO_LINES_ARCHIVE_ALL POLA

182: -- SQL Join: po_line_id, category_id
183: SELECT DISTINCT 'Y'
184: INTO x_lines_control.category_id
185: FROM PO_LINES_ALL POL,
186: PO_LINES_ARCHIVE_ALL POLA
187: WHERE POL.po_header_id = x_po_header_id
188: AND POL.po_line_id = POLA.po_line_id (+)
189: AND POLA.latest_external_flag (+) = 'Y'
190: AND (

Line 209: PO_LINES_ARCHIVE_ALL POLA

205: -- SQL Join: po_line_id, item_description
206: SELECT DISTINCT 'Y'
207: INTO x_lines_control.item_description
208: FROM PO_LINES_ALL POL,
209: PO_LINES_ARCHIVE_ALL POLA
210: WHERE POL.po_header_id = x_po_header_id
211: AND POL.po_line_id = POLA.po_line_id (+)
212: AND POLA.latest_external_flag (+) = 'Y'
213: AND (

Line 232: PO_LINES_ARCHIVE_ALL POLA

228: -- SQL Join: po_line_id, unit_meas_lookup_code
229: SELECT DISTINCT 'Y'
230: INTO x_lines_control.unit_meas_lookup_code
231: FROM PO_LINES_ALL POL,
232: PO_LINES_ARCHIVE_ALL POLA
233: WHERE POL.po_header_id = x_po_header_id
234: AND POL.po_line_id = POLA.po_line_id (+)
235: AND POLA.latest_external_flag (+) = 'Y'
236: AND (

Line 255: PO_LINES_ARCHIVE_ALL POLA

251: -- SQL Join: po_line_id, un_number_id
252: SELECT DISTINCT 'Y'
253: INTO x_lines_control.un_number_id
254: FROM PO_LINES_ALL POL,
255: PO_LINES_ARCHIVE_ALL POLA
256: WHERE POL.po_header_id = x_po_header_id
257: AND POL.po_line_id = POLA.po_line_id (+)
258: AND POLA.latest_external_flag (+) = 'Y'
259: AND (

Line 278: PO_LINES_ARCHIVE_ALL POLA

274: -- SQL Join: po_line_id, hazard_class_id
275: SELECT DISTINCT 'Y'
276: INTO x_lines_control.hazard_class_id
277: FROM PO_LINES_ALL POL,
278: PO_LINES_ARCHIVE_ALL POLA
279: WHERE POL.po_header_id = x_po_header_id
280: AND POL.po_line_id = POLA.po_line_id (+)
281: AND POLA.latest_external_flag (+) = 'Y'
282: AND (

Line 301: PO_LINES_ARCHIVE_ALL POLA

297: -- SQL Join: po_line_id, note_to_vendor
298: SELECT DISTINCT 'Y'
299: INTO x_lines_control.note_to_vendor
300: FROM PO_LINES_ALL POL,
301: PO_LINES_ARCHIVE_ALL POLA
302: WHERE POL.po_header_id = x_po_header_id
303: AND POL.po_line_id = POLA.po_line_id (+)
304: AND POLA.latest_external_flag (+) = 'Y'
305: AND (

Line 324: PO_LINES_ARCHIVE_ALL POLA

320: -- SQL Join: po_line_id, from_header_id
321: SELECT DISTINCT 'Y'
322: INTO x_lines_control.from_header_id
323: FROM PO_LINES_ALL POL,
324: PO_LINES_ARCHIVE_ALL POLA
325: WHERE POL.po_header_id = x_po_header_id
326: AND POL.po_line_id = POLA.po_line_id (+)
327: AND POLA.latest_external_flag (+) = 'Y'
328: AND (

Line 347: PO_LINES_ARCHIVE_ALL POLA

343: -- SQL Join: po_line_id, from_line_id
344: SELECT DISTINCT 'Y'
345: INTO x_lines_control.from_line_id
346: FROM PO_LINES_ALL POL,
347: PO_LINES_ARCHIVE_ALL POLA
348: WHERE POL.po_header_id = x_po_header_id
349: AND POL.po_line_id = POLA.po_line_id (+)
350: AND POLA.latest_external_flag (+) = 'Y'
351: AND (

Line 370: PO_LINES_ARCHIVE_ALL POLA

366: -- SQL Join: po_line_id, closed_code
367: SELECT DISTINCT 'Y'
368: INTO x_lines_control.closed_code
369: FROM PO_LINES_ALL POL,
370: PO_LINES_ARCHIVE_ALL POLA
371: WHERE POL.po_header_id = x_po_header_id
372: AND POL.po_line_id = POLA.po_line_id (+)
373: AND POLA.latest_external_flag (+) = 'Y'
374: AND (

Line 393: PO_LINES_ARCHIVE_ALL POLA

389: -- SQL Join: po_line_id, vendor_product_num
390: SELECT DISTINCT 'Y'
391: INTO x_lines_control.vendor_product_num
392: FROM PO_LINES_ALL POL,
393: PO_LINES_ARCHIVE_ALL POLA
394: WHERE POL.po_header_id = x_po_header_id
395: AND POL.po_line_id = POLA.po_line_id (+)
396: AND POLA.latest_external_flag (+) = 'Y'
397: AND (

Line 417: PO_LINES_ARCHIVE_ALL POLA

413: -- SQL Join: po_line_id, contract_id
414: SELECT DISTINCT 'Y'
415: INTO x_lines_control.contract_num
416: FROM PO_LINES_ALL POL,
417: PO_LINES_ARCHIVE_ALL POLA
418: WHERE POL.po_header_id = x_po_header_id
419: AND POL.po_line_id = POLA.po_line_id (+)
420: AND POLA.latest_external_flag (+) = 'Y'
421: AND (

Line 443: PO_LINES_ARCHIVE_ALL POLA

439: -- SQL Join: po_line_id, price_type_lookup_code
440: SELECT DISTINCT 'Y'
441: INTO x_lines_control.price_type_lookup_code
442: FROM PO_LINES_ALL POL,
443: PO_LINES_ARCHIVE_ALL POLA
444: WHERE POL.po_header_id = x_po_header_id
445: AND POL.po_line_id = POLA.po_line_id (+)
446: AND POLA.latest_external_flag (+) = 'Y'
447: AND (

Line 466: PO_LINES_ARCHIVE_ALL POLA

462: -- SQL Join: po_line_id, cancel_flag
463: SELECT DISTINCT 'Y'
464: INTO x_lines_control.cancel_flag
465: FROM PO_LINES_ALL POL,
466: PO_LINES_ARCHIVE_ALL POLA
467: WHERE POL.po_header_id = x_po_header_id
468: AND POL.po_line_id = POLA.po_line_id (+)
469: AND POLA.latest_external_flag (+) = 'Y'
470: AND (

Line 492: po_lines_archive_all pola

488:
489: SELECT DISTINCT 'Y'
490: INTO x_lines_control.retainage_rate
491: FROM po_lines_all pol,
492: po_lines_archive_all pola
493: WHERE pol.po_header_id = x_po_header_id
494: AND pol.po_line_id = pola.po_line_id (+)
495: AND pola.latest_external_flag (+) = 'Y'
496: AND (

Line 516: po_lines_archive_all pola

512:
513: SELECT DISTINCT 'Y'
514: INTO x_lines_control.max_retainage_amount
515: FROM po_lines_all pol,
516: po_lines_archive_all pola
517: WHERE pol.po_header_id = x_po_header_id
518: AND pol.po_line_id = pola.po_line_id (+)
519: AND pola.latest_external_flag (+) = 'Y'
520: AND (

Line 540: po_lines_archive_all pola

536:
537: SELECT DISTINCT 'Y'
538: INTO x_lines_control.progress_payment_rate
539: FROM po_lines_all pol,
540: po_lines_archive_all pola
541: WHERE pol.po_header_id = x_po_header_id
542: AND pol.po_line_id = pola.po_line_id (+)
543: AND pola.latest_external_flag (+) = 'Y'
544: AND (

Line 566: po_lines_archive_all pola

562:
563: SELECT DISTINCT 'Y'
564: INTO x_lines_control.recoupment_rate
565: FROM po_lines_all pol,
566: po_lines_archive_all pola
567: WHERE pol.po_header_id = x_po_header_id
568: AND pol.po_line_id = pola.po_line_id (+)
569: AND pola.latest_external_flag (+) = 'Y'
570: AND (

Line 620: PO_LINES_ARCHIVE_ALL POLA

616: SELECT max(po_chord_wf0.percentage_change(
617: POLA.quantity, POL.quantity))
618: INTO x_lines_control.quantity_change
619: FROM PO_LINES_ALL POL,
620: PO_LINES_ARCHIVE_ALL POLA
621: WHERE POL.po_header_id = x_po_header_id
622: AND POL.po_line_id = POLA.po_line_id (+)
623: AND POLA.latest_external_flag (+) = 'Y';
624:

Line 640: PO_LINES_ARCHIVE_ALL POLA

636: SELECT max(po_chord_wf0.percentage_change(
637: POLA.unit_price, POL.unit_price))
638: INTO x_lines_control.unit_price_change
639: FROM PO_LINES_ALL POL,
640: PO_LINES_ARCHIVE_ALL POLA
641: WHERE POL.po_header_id = x_po_header_id
642: AND POL.po_line_id = POLA.po_line_id (+)
643: AND POLA.latest_external_flag (+) = 'Y';
644:

Line 660: PO_LINES_ARCHIVE_ALL POLA

656: SELECT max(po_chord_wf0.percentage_change(
657: POLA.not_to_exceed_price, POL.not_to_exceed_price))
658: INTO x_lines_control.not_to_exceed_price_change
659: FROM PO_LINES_ALL POL,
660: PO_LINES_ARCHIVE_ALL POLA
661: WHERE POL.po_header_id = x_po_header_id
662: AND POL.po_line_id = POLA.po_line_id (+)
663: AND POLA.latest_external_flag (+) = 'Y';
664:

Line 680: PO_LINES_ARCHIVE_ALL POLA

676: SELECT max(po_chord_wf0.percentage_change(
677: POLA.quantity_committed, POL.quantity_committed))
678: INTO x_lines_control.quantity_committed_change
679: FROM PO_LINES_ALL POL,
680: PO_LINES_ARCHIVE_ALL POLA
681: WHERE POL.po_header_id = x_po_header_id
682: AND POL.po_line_id = POLA.po_line_id (+)
683: AND POLA.latest_external_flag (+) = 'Y';
684:

Line 700: PO_LINES_ARCHIVE_ALL POLA

696: SELECT max(po_chord_wf0.percentage_change(
697: POLA.committed_amount, POL.committed_amount))
698: INTO x_lines_control.committed_amount_change
699: FROM PO_LINES_ALL POL,
700: PO_LINES_ARCHIVE_ALL POLA
701: WHERE POL.po_header_id = x_po_header_id
702: AND POL.po_line_id = POLA.po_line_id (+)
703: AND POLA.latest_external_flag (+) = 'Y';
704:

Line 744: PO_LINES_ARCHIVE_ALL POLA

740: (POL.quantity*POL.unit_price)) / l_min_acct_unit )* l_min_acct_unit
741: ) )
742: INTO x_lines_control.amount_change
743: FROM PO_LINES_ALL POL,
744: PO_LINES_ARCHIVE_ALL POLA
745: WHERE POL.po_header_id = x_po_header_id
746: AND POL.po_line_id = POLA.po_line_id (+)
747: AND POLA.latest_external_flag (+) = 'Y';
748:

Line 760: PO_LINES_ARCHIVE_ALL POLA

756: (POL.quantity*POL.unit_price )) , l_precision)
757: ) )
758: INTO x_lines_control.amount_change
759: FROM PO_LINES_ALL POL,
760: PO_LINES_ARCHIVE_ALL POLA
761: WHERE POL.po_header_id = x_po_header_id
762: AND POL.po_line_id = POLA.po_line_id (+)
763: AND POLA.latest_external_flag (+) = 'Y';
764: END IF;

Line 780: PO_LINES_ARCHIVE_ALL POLA

776: BEGIN
777: SELECT max(trunc(POL.start_date-POLA.start_date))
778: INTO x_lines_control.start_date_change
779: FROM PO_LINES_ALL POL,
780: PO_LINES_ARCHIVE_ALL POLA
781: WHERE POL.po_header_id = x_po_header_id
782: AND POL.po_line_id = POLA.po_line_id (+)
783: AND POLA.latest_external_flag (+) = 'Y';
784:

Line 799: PO_LINES_ARCHIVE_ALL POLA

795: -- SQL Join: po_line_id, line_num
796: SELECT DISTINCT 'Y'
797: INTO x_lines_control.end_date
798: FROM PO_LINES POL,
799: PO_LINES_ARCHIVE_ALL POLA
800: WHERE POL.po_header_id = x_po_header_id
801: AND POL.po_line_id = POLA.po_line_id (+)
802: AND POLA.latest_external_flag (+) = 'Y'
803: AND (

Line 818: PO_LINES_ARCHIVE_ALL POLA

814:
815: SELECT max(trunc(POL.expiration_date-POLA.expiration_date))
816: INTO x_lines_control.end_date_change
817: FROM PO_LINES_ALL POL,
818: PO_LINES_ARCHIVE_ALL POLA
819: WHERE POL.po_header_id = x_po_header_id
820: AND POL.po_line_id = POLA.po_line_id (+)
821: AND POLA.latest_external_flag (+) = 'Y'
822: AND (POL.expiration_date IS NOT NULL OR POLA.expiration_date IS NOT NULL);