DBA Data[Home] [Help]

APPS.PO_CHORD_WF1 dependencies on PO_HEADERS_ARCHIVE_ALL

Line 134: PO_HEADERS_ARCHIVE_all POHA

130: -- SQL Join: po_header_id, agent_id
131: SELECT DISTINCT 'Y'
132: INTO x_header_control.agent_id
133: FROM PO_HEADERS_all POH,
134: PO_HEADERS_ARCHIVE_all POHA
135: WHERE POH.po_header_id = x_po_header_id
136: AND POH.po_header_id = POHA.po_header_id (+)
137: AND POHA.latest_external_flag (+) = 'Y'
138: AND (

Line 154: PO_HEADERS_ARCHIVE_all POHA

150: -- SQL Join: po_header_id, vendor_site_id
151: SELECT DISTINCT 'Y'
152: INTO x_header_control.vendor_site_id
153: FROM PO_HEADERS_all POH,
154: PO_HEADERS_ARCHIVE_all POHA
155: WHERE POH.po_header_id = x_po_header_id
156: AND POH.po_header_id = POHA.po_header_id (+)
157: AND POHA.latest_external_flag (+) = 'Y'
158: AND (

Line 179: PO_HEADERS_ARCHIVE_all POHA

175: -- SQL Join: po_header_id, vendor_contact_id
176: SELECT DISTINCT 'Y'
177: INTO x_header_control.vendor_contact_id
178: FROM PO_HEADERS_all POH,
179: PO_HEADERS_ARCHIVE_all POHA
180: WHERE POH.po_header_id = x_po_header_id
181: AND POH.po_header_id = POHA.po_header_id (+)
182: AND POHA.latest_external_flag (+) = 'Y'
183: AND (

Line 204: PO_HEADERS_ARCHIVE_all POHA

200: -- SQL Join: po_header_id, ship_to_location_id
201: SELECT DISTINCT 'Y'
202: INTO x_header_control.ship_to_location_id
203: FROM PO_HEADERS_all POH,
204: PO_HEADERS_ARCHIVE_all POHA
205: WHERE POH.po_header_id = x_po_header_id
206: AND POH.po_header_id = POHA.po_header_id (+)
207: AND POHA.latest_external_flag (+) = 'Y'
208: AND (

Line 229: PO_HEADERS_ARCHIVE_all POHA

225: -- SQL Join: po_header_id, bill_to_location_id
226: SELECT DISTINCT 'Y'
227: INTO x_header_control.bill_to_location_id
228: FROM PO_HEADERS_all POH,
229: PO_HEADERS_ARCHIVE_all POHA
230: WHERE POH.po_header_id = x_po_header_id
231: AND POH.po_header_id = POHA.po_header_id (+)
232: AND POHA.latest_external_flag (+) = 'Y'
233: AND (

Line 255: PO_HEADERS_ARCHIVE_all POHA

251: -- SQL Join: po_header_id, terms_id
252: SELECT DISTINCT 'Y'
253: INTO x_header_control.terms_id
254: FROM PO_HEADERS_all POH,
255: PO_HEADERS_ARCHIVE_all POHA
256: WHERE POH.po_header_id = x_po_header_id
257: AND POH.po_header_id = POHA.po_header_id (+)
258: AND POHA.latest_external_flag (+) = 'Y'
259: AND (

Line 281: PO_HEADERS_ARCHIVE_all POHA

277: -- SQL Join: po_header_id, ship_via_lookup_code
278: SELECT DISTINCT 'Y'
279: INTO x_header_control.ship_via_lookup_code
280: FROM PO_HEADERS_all POH,
281: PO_HEADERS_ARCHIVE_all POHA
282: WHERE POH.po_header_id = x_po_header_id
283: AND POH.po_header_id = POHA.po_header_id (+)
284: AND POHA.latest_external_flag (+) = 'Y'
285: AND (

Line 307: PO_HEADERS_ARCHIVE_all POHA

303: -- SQL Join: po_header_id, fob_lookup_code
304: SELECT DISTINCT 'Y'
305: INTO x_header_control.fob_lookup_code
306: FROM PO_HEADERS_all POH,
307: PO_HEADERS_ARCHIVE_all POHA
308: WHERE POH.po_header_id = x_po_header_id
309: AND POH.po_header_id = POHA.po_header_id (+)
310: AND POHA.latest_external_flag (+) = 'Y'
311: AND (

Line 332: PO_HEADERS_ARCHIVE_all POHA

328: -- SQL Join: po_header_id, freight_terms_lookup_code
329: SELECT DISTINCT 'Y'
330: INTO x_header_control.freight_terms_lookup_code
331: FROM PO_HEADERS_all POH,
332: PO_HEADERS_ARCHIVE_all POHA
333: WHERE POH.po_header_id = x_po_header_id
334: AND POH.po_header_id = POHA.po_header_id (+)
335: AND POHA.latest_external_flag (+) = 'Y'
336: AND (

Line 358: PO_HEADERS_ARCHIVE_all POHA

354: -- SQL Join: po_header_id, note_to_vendor
355: SELECT DISTINCT 'Y'
356: INTO x_header_control.note_to_vendor
357: FROM PO_HEADERS_all POH,
358: PO_HEADERS_ARCHIVE_all POHA
359: WHERE POH.po_header_id = x_po_header_id
360: AND POH.po_header_id = POHA.po_header_id (+)
361: AND POHA.latest_external_flag (+) = 'Y'
362: AND (

Line 384: PO_HEADERS_ARCHIVE_all POHA

380: -- SQL Join: po_header_id, confirming_order_flag
381: SELECT DISTINCT 'Y'
382: INTO x_header_control.confirming_order_flag
383: FROM PO_HEADERS_all POH,
384: PO_HEADERS_ARCHIVE_all POHA
385: WHERE POH.po_header_id = x_po_header_id
386: AND POH.po_header_id = POHA.po_header_id (+)
387: AND POHA.latest_external_flag (+) = 'Y'
388: AND (

Line 409: PO_HEADERS_ARCHIVE_all POHA

405: -- SQL Join: po_header_id, acceptance_required_flag
406: SELECT DISTINCT 'Y'
407: INTO x_header_control.acceptance_required_flag
408: FROM PO_HEADERS_all POH,
409: PO_HEADERS_ARCHIVE_all POHA
410: WHERE POH.po_header_id = x_po_header_id
411: AND POH.po_header_id = POHA.po_header_id (+)
412: AND POHA.latest_external_flag (+) = 'Y'
413: AND (

Line 434: PO_HEADERS_ARCHIVE_all POHA

430: -- SQL Join: po_header_id, acceptance_due_date
431: SELECT DISTINCT 'Y'
432: INTO x_header_control.acceptance_due_date
433: FROM PO_HEADERS_all POH,
434: PO_HEADERS_ARCHIVE_all POHA
435: WHERE POH.po_header_id = x_po_header_id
436: AND POH.po_header_id = POHA.po_header_id (+)
437: AND POHA.latest_external_flag (+) = 'Y'
438: AND (

Line 459: PO_HEADERS_ARCHIVE_all POHA

455: -- SQL Join: po_header_id
456: SELECT DISTINCT 'Y'
457: INTO x_header_control.start_date
458: FROM PO_HEADERS_all POH,
459: PO_HEADERS_ARCHIVE_all POHA
460: WHERE POH.po_header_id = x_po_header_id
461: AND POH.po_header_id = POHA.po_header_id (+)
462: AND POHA.latest_external_flag (+) = 'Y'
463: AND (

Line 485: PO_HEADERS_ARCHIVE_all POHA

481: -- SQL Join: po_header_id
482: SELECT DISTINCT 'Y'
483: INTO x_header_control.end_date
484: FROM PO_HEADERS_all POH,
485: PO_HEADERS_ARCHIVE_all POHA
486: WHERE POH.po_header_id = x_po_header_id
487: AND POH.po_header_id = POHA.po_header_id (+)
488: AND POHA.latest_external_flag (+) = 'Y'
489: AND (

Line 511: PO_HEADERS_ARCHIVE_all POHA

507: -- SQL Join: po_header_id, cancel_flag
508: SELECT DISTINCT 'Y'
509: INTO x_header_control.cancel_flag
510: FROM PO_HEADERS_all POH,
511: PO_HEADERS_ARCHIVE_all POHA
512: WHERE POH.po_header_id = x_po_header_id
513: AND POH.po_header_id = POHA.po_header_id (+)
514: AND POHA.latest_external_flag (+) = 'Y'
515: AND (

Line 548: PO_HEADERS_ARCHIVE_all POHA

544: / decode(nvl(POHA.blanket_total_amount,0),0,1,
545: POHA.blanket_total_amount)*100)
546: INTO x_header_control.blanket_total_change
547: FROM PO_HEADERS_all POH,
548: PO_HEADERS_ARCHIVE_all POHA
549: WHERE POH.po_header_id = x_po_header_id
550: AND POH.po_header_id = POHA.po_header_id (+)
551: AND POHA.latest_external_flag (+) = 'Y';
552: EXCEPTION

Line 567: PO_HEADERS_ARCHIVE_all POHA

563: BEGIN
564: SELECT DISTINCT 'Y'
565: INTO x_header_control.amount_limit
566: FROM PO_HEADERS_all POH,
567: PO_HEADERS_ARCHIVE_all POHA
568: WHERE POH.po_header_id = x_po_header_id
569: AND POH.po_header_id = POHA.po_header_id (+)
570: AND POHA.latest_external_flag (+) = 'Y'
571: AND ((POH.amount_limit IS NULL AND

Line 602: PO_HEADERS_ARCHIVE_all POHA

598: / decode(nvl(POHA.amount_limit,0),0,1,POHA.amount_limit)
599: *100)
600: INTO x_header_control.amount_limit_change
601: FROM PO_HEADERS_all POH,
602: PO_HEADERS_ARCHIVE_all POHA
603: WHERE POH.po_header_id = x_po_header_id
604: AND POH.po_header_id = POHA.po_header_id (+)
605: AND POHA.latest_external_flag (+) = 'Y';
606: EXCEPTION