APPS.PO_ASL_UPGRADE_SV2 dependencies on PO_AUTOSOURCE_DOCUMENTS

Line 393: FROM po_autosource_documents_all pad,

389: -- the document is effective.
390:
391: SELECT doc_generation_method
392: INTO x_release_generation_method
393: FROM po_autosource_documents_all pad,
394: po_autosource_rules par
395: WHERE pad.autosource_rule_id = par.autosource_rule_id
396: AND par.item_id = x_item_id
397: AND pad.vendor_id = x_vendor_id

Line 403: FROM po_autosource_documents_all pad2,

399: AND par.end_date > sysdate
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'

Line 426: po_autosource_documents_all pad

422:
423: SELECT pad.doc_generation_method
424: INTO x_release_generation_method
425: FROM po_autosource_rules par,
426: po_autosource_documents_all pad
427: WHERE par.item_id = x_item_id
428: AND pad.vendor_id = x_vendor_id
429: AND rownum < 2
430: AND par.autosource_rule_id = pad.autosource_rule_id

Line 433: FROM po_autosource_documents_all pad3,

429: AND rownum < 2
430: AND par.autosource_rule_id = pad.autosource_rule_id
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

Line 446: FROM po_autosource_documents_all pad2,

442: AND par3.start_date > sysdate
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'

Line 549: x_document_type_code po_autosource_documents.document_type_code%type;

545: x_last_updated_by NUMBER;
546: x_created_by NUMBER;
547: x_creation_date DATE;
548: x_request_id NUMBER;
549: x_document_type_code po_autosource_documents.document_type_code%type;
550: x_doc_generation_method po_autosource_documents.doc_generation_method%type;
551:
552: CURSOR C IS
553: SELECT pad.document_type_code,

Line 550: x_doc_generation_method po_autosource_documents.doc_generation_method%type;

546: x_created_by NUMBER;
547: x_creation_date DATE;
548: x_request_id NUMBER;
549: x_document_type_code po_autosource_documents.document_type_code%type;
550: x_doc_generation_method po_autosource_documents.doc_generation_method%type;
551:
552: CURSOR C IS
553: SELECT pad.document_type_code,
554: pad.document_header_id,

Line 563: FROM PO_AUTOSOURCE_DOCUMENTS_all pad,

559: pad.creation_date,
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