DBA Data[Home] [Help]

APPS.PO_CORE_S3 dependencies on PO_HEADERS_DRAFT_ALL

Line 758: FROM po_headers_draft_all pohd,

754: FROM po_drafts pd1
755: WHERE pd1.draft_id = pohd.mod_draft_id)),
756: pd.status)
757: INTO line_status_code
758: FROM po_headers_draft_all pohd,
759: po_drafts pd
760: WHERE pd.draft_id = p_draft_id
761: AND pd.document_id = p_po_header_id
762: AND pohd.po_header_id = pd.document_id

Line 769: FROM po_headers_draft_all pohd,

765:
766: IF line_status_code IS NULL THEN
767: SELECT pd.status
768: INTO line_status_code
769: FROM po_headers_draft_all pohd,
770: po_drafts pd
771: WHERE pd.draft_id = p_draft_id
772: AND pd.document_id = p_po_header_id
773: AND pohd.po_header_id = pd.document_id