eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CLM_CAR_UTIL dependencies on PO_DOC_NUMBERING_PKG

Line 550: SELECT replace(CLM_DOCUMENT_NUMBER, PO_DOC_NUMBERING_PKG.GET_DELIMITER_FOR_DOC (po_header_id, draft_id), '')

546: p_draft_id IN NUMBER
547: ) RETURN VARCHAR2 IS
548: l_PIID VARCHAR2(60);
549: BEGIN
550: SELECT replace(CLM_DOCUMENT_NUMBER, PO_DOC_NUMBERING_PKG.GET_DELIMITER_FOR_DOC (po_header_id, draft_id), '')
551: INTO l_piid
552: from PO_HEADERS_MERGE_V
553: WHERE po_header_id = p_po_header_id
554: AND draft_id = NVL(p_draft_id, -1);

Line 566: SELECT REPLACE(MODIFICATION_NUMBER, CLM_DOCUMENT_NUMBER||PO_DOC_NUMBERING_PKG.GET_DELIMITER_FOR_DOC (POH.po_header_id, POH.draft_id), '')

562: p_draft_id IN NUMBER
563: ) RETURN VARCHAR2 IS
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