DBA Data[Home] [Help]

APPS.PO_ASL_UPGRADE_SV2 dependencies on PO_AUTOSOURCE_RULES

Line 394: po_autosource_rules par

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
398: AND par.start_date <= sysdate

Line 425: FROM po_autosource_rules par,

421: -- blanket.
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

Line 434: po_autosource_rules par3,

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
438: AND par3.item_id = x_item_id