DBA Data[Home] [Help]

APPS.PO_CORE_S3 dependencies on PO_DRAFTS

Line 754: FROM po_drafts pd1

750: WHERE prl.par_draft_id = pd.draft_id),
751: (SELECT DECODE(pd1.status,
752: 'COMPLETED', 'PO_CREATED',
753: 'MOD_CREATED')
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,

Line 759: po_drafts pd

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
763: AND pohd.draft_id = pd.draft_id;

Line 770: po_drafts pd

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
774: AND pohd.draft_id = pd.draft_id;