DBA Data[Home] [Help]

APPS.PO_CHORD_WF2 dependencies on PO_LINES_ALL

Line 139: FROM PO_LINES_ALL POL,

135: -- if there is a change
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'

Line 162: FROM PO_LINES_ALL POL,

158: -- if there is a change
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'

Line 185: FROM PO_LINES_ALL POL,

181: -- if there is a change
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'

Line 208: FROM PO_LINES_ALL POL,

204: -- if there is a change
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'

Line 231: FROM PO_LINES_ALL POL,

227: -- if there is a change
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'

Line 254: FROM PO_LINES_ALL POL,

250: -- if there is a change
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'

Line 277: FROM PO_LINES_ALL POL,

273: -- if there is a change
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'

Line 300: FROM PO_LINES_ALL POL,

296: -- if there is a change
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'

Line 323: FROM PO_LINES_ALL POL,

319: -- if there is a change
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'

Line 346: FROM PO_LINES_ALL POL,

342: -- if there is a change
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'

Line 369: FROM PO_LINES_ALL POL,

365: -- if there is a change
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'

Line 392: FROM PO_LINES_ALL POL,

388: -- if there is a change
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'

Line 416: FROM PO_LINES_ALL POL,

412: -- if there is a change
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'

Line 442: FROM PO_LINES_ALL POL,

438: -- if there is a change
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'

Line 465: FROM PO_LINES_ALL POL,

461: -- if there is a change
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'

Line 491: FROM po_lines_all pol,

487: -- SQL Join: po_line_id
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'

Line 515: FROM po_lines_all pol,

511: -- SQL Join: po_line_id
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'

Line 539: FROM po_lines_all pol,

535: -- SQL Join: po_line_id
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'

Line 565: FROM po_lines_all pol,

561: -- SQL Join: po_line_id
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'

Line 619: FROM PO_LINES_ALL POL,

615: -- SQL Join: po_line_id
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';

Line 639: FROM PO_LINES_ALL POL,

635: -- SQL Join: po_line_id
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';

Line 659: FROM PO_LINES_ALL POL,

655: -- SQL Join: po_line_id
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';

Line 679: FROM PO_LINES_ALL POL,

675: -- SQL Join: po_line_id
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';

Line 699: FROM PO_LINES_ALL POL,

695: -- SQL Join: po_line_id
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';

Line 743: FROM PO_LINES_ALL POL,

739: decode(POL.order_type_lookup_code, 'RATE',POL.amount,'FIXED PRICE', POL.amount,
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';

Line 759: FROM PO_LINES_ALL POL,

755: decode(POL.order_type_lookup_code, 'RATE',POL.amount,'FIXED PRICE', POL.amount,
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';

Line 779: FROM PO_LINES_ALL POL,

775: -- SQL Join: line_id
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';

Line 817: FROM PO_LINES_ALL POL,

813: -- SQL Join: line_id
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'