APPS.PO_CLM_CAR_UTIL dependencies on PO_DRAFTS

Line 535: FROM PO_DRAFTS POD, PO_HEADERS_MERGE_V POH

531: l_car_number VARCHAR2(60);
532: BEGIN
533: SELECT DECODE(POH.draft_id, -1, POH.clm_document_number, POD.modification_number)
534: INTO l_car_number
535: FROM PO_DRAFTS POD, PO_HEADERS_MERGE_V POH
536: WHERE POH.DRAFT_ID = POD.DRAFT_ID(+)
537: AND POH.po_header_id = p_po_header_id
538: AND poh.draft_id = NVL(p_draft_id, -1);
539:

Line 568: FROM PO_DRAFTS POD, PO_HEADERS_MERGE_V POH

564: l_modification_segment VARCHAR2(60);
565: BEGIN
566: SELECT REPLACE(MODIFICATION_NUMBER, CLM_DOCUMENT_NUMBER||PO_DOC_NUMBERING_PKG.GET_DELIMITER_FOR_DOC (POH.po_header_id, POH.draft_id), '')
567: INTO l_modification_segment
568: FROM PO_DRAFTS POD, PO_HEADERS_MERGE_V POH
569: WHERE POH.DRAFT_ID = POD.DRAFT_ID(+)
570: AND POH.po_header_id = p_po_header_id
571: AND poh.draft_id = NVL(p_draft_id, -1);
572: