DBA Data[Home] [Help]

APPS.PO_ASL_UPGRADE_SV2 dependencies on PO_HEADERS_ALL

Line 404: po_headers_all poh

400: AND rownum < 2
401: AND pad.sequence_num =
402: (SELECT min(sequence_num)
403: FROM po_autosource_documents_all pad2,
404: po_headers_all poh
405: WHERE pad2.autosource_rule_id = pad.autosource_rule_id
406: AND pad2.vendor_id = x_vendor_id
407: AND pad2.document_type_code = 'BLANKET'
408: AND pad2.document_header_id = poh.po_header_id

Line 435: po_headers_all poh3

431: AND par.start_date =
432: (SELECT min(par3.start_date)
433: FROM po_autosource_documents_all pad3,
434: po_autosource_rules par3,
435: po_headers_all poh3
436: WHERE par3.autosource_rule_id = pad3.autosource_rule_id
437: AND pad3.vendor_id = x_vendor_id
438: AND par3.item_id = x_item_id
439: AND pad3.document_header_id = poh3.po_header_id

Line 447: po_headers_all poh2

443: AND pad3.document_type_code = 'BLANKET')
444: AND pad.sequence_num =
445: (SELECT min(sequence_num)
446: FROM po_autosource_documents_all pad2,
447: po_headers_all poh2
448: WHERE pad2.autosource_rule_id = pad.autosource_rule_id
449: AND pad2.vendor_id = x_vendor_id
450: AND pad2.document_type_code = 'BLANKET'
451: AND pad2.document_header_id = poh2.po_header_id

Line 564: PO_HEADERS_all poh

560: pad.created_by,
561: pad.doc_generation_method,
562: pad.org_id
563: FROM PO_AUTOSOURCE_DOCUMENTS_all pad,
564: PO_HEADERS_all poh
565: WHERE pad.autosource_rule_id = x_autosource_rule_id
566: AND pad.vendor_id = x_vendor_id
567: AND poh.po_header_id = pad.document_header_id
568: AND sysdate >= nvl(poh.start_date, sysdate-1)