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.

VIEW: APPS.IGC_CC_SLA_BFLOW_PRIOR_V

Source

View Text - Preformatted


SELECT 'Y' CC_LINE , 8407 IGC_APPLICATION_ID , 'CC_CONTRACTS' CC_ENTITY_CODE , 'CC' CC_DIST_TYPE , nvl(pf.parent_acct_line_id, pf.cc_acct_line_id) cc_dist_id , nvl(h.parent_header_id, h.cc_header_id) cc_doc_id , pd.po_distribution_id , h.cc_num , h.cc_version_num , h.cc_header_id FROM igc_cc_headers_all h , igc_cc_det_pf pf , po_distributions_all pd , po_lines_all pl , po_line_types plt WHERE pl.po_line_id = pd.po_line_id and pl.line_type_id = plt.line_type_id and plt.line_type = 'IGC CONTRACT COMMITMENT' and pd.req_header_reference_num = to_char(h.cc_header_id) and pd.req_line_reference_num = to_char(pf.cc_det_pf_line_id)

View Text - HTML Formatted

SELECT 'Y' CC_LINE
, 8407 IGC_APPLICATION_ID
, 'CC_CONTRACTS' CC_ENTITY_CODE
, 'CC' CC_DIST_TYPE
, NVL(PF.PARENT_ACCT_LINE_ID
, PF.CC_ACCT_LINE_ID) CC_DIST_ID
, NVL(H.PARENT_HEADER_ID
, H.CC_HEADER_ID) CC_DOC_ID
, PD.PO_DISTRIBUTION_ID
, H.CC_NUM
, H.CC_VERSION_NUM
, H.CC_HEADER_ID
FROM IGC_CC_HEADERS_ALL H
, IGC_CC_DET_PF PF
, PO_DISTRIBUTIONS_ALL PD
, PO_LINES_ALL PL
, PO_LINE_TYPES PLT
WHERE PL.PO_LINE_ID = PD.PO_LINE_ID
AND PL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PLT.LINE_TYPE = 'IGC CONTRACT COMMITMENT'
AND PD.REQ_HEADER_REFERENCE_NUM = TO_CHAR(H.CC_HEADER_ID)
AND PD.REQ_LINE_REFERENCE_NUM = TO_CHAR(PF.CC_DET_PF_LINE_ID)