ECC Contract Lifecycle Management, Requisitions, SQL10

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Requisitions Data Set
Dataset Key: po-clm-requisitions
Query Procedure: PO_ICX_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesReq
select
x.*
from
(
select ecc_spec_id  , max( DRAWING_NUM ) as DRAWING_NUM, max( EXTND_DESC ) as EXTND_DESC, max( MANF_NAME ) as MANF_NAME, max( MANF_PART_NUM ) as MANF_PART_NUM, max( MODEL_NUM ) as MODEL_NUM, max( NSN ) as NSN, max( PIECE_NUM ) as PIECE_NUM, max( PR_CT_NUM ) as PR_CT_NUM, max( SERIAL_NUM ) as SERIAL_NUM, max( SPEC_NUM ) as SPEC_NUM, max( VND_PRT_NUM ) as VND_PRT_NUM, max( AWARD_FEE ) as AWARD_FEE, max( TOTAL_AMOUNT ) as TOTAL_AMOUNT, max( QUANTITY ) as QUANTITY, max( UOM ) as UOM, max( BASE_FEE ) as BASE_FEE, max( ESTIMATED_COST ) as ESTIMATED_COST, max( FIXED_FEE ) as FIXED_FEE, max( FIXED_FEE_PER ) as FIXED_FEE_PER, max( MAXIMUM_COST ) as MAXIMUM_COST, max( GOVT_SH_AB_TARGET ) as GOVT_SH_AB_TARGET, max( GOVT_SH_BE_TARGET ) as GOVT_SH_BE_TARGET, max( MAXIMUM_FEE ) as MAXIMUM_FEE, max( MINIMUM_FEE ) as MINIMUM_FEE, max( TARGET_COST ) as TARGET_COST, max( TARGET_FEE ) as TARGET_FEE, max( CONT_SH_AMOUNT ) as CONT_SH_AMOUNT, max( GOVT_SHARE_PER ) as GOVT_SHARE_PER, max( GOVT_SH_AMOUNT ) as GOVT_SH_AMOUNT, max( UNIT_PRICE ) as UNIT_PRICE, max( MINIMUM_QUANTITY ) as MINIMUM_QUANTITY, max( CEILING_PRICE ) as CEILING_PRICE, max( CEILING_PRICE_PER ) as CEILING_PRICE_PER, max( TARGET_PROFIT ) as TARGET_PROFIT, max( TAR_UNIT_PRICE ) as TAR_UNIT_PRICE, max( TOT_TAR_PRICE ) as TOT_TAR_PRICE, max( CEIL_FTP ) as CEIL_FTP, max( FLOOR_FTP ) as FLOOR_FTP, max( MINIMUM_HOURS ) as MINIMUM_HOURS, max( DIRECT_COSTS ) as DIRECT_COSTS, max( MAXIMUM_PRICE ) as MAXIMUM_PRICE, max( MAXIMUM_QTY ) as MAXIMUM_QTY, max( CUST_PRJ_CODE ) as CUST_PRJ_CODE, max( CUST_PRJ_TXT ) as CUST_PRJ_TXT, nvl(max( FSC_PSC ),'NA') as FSC_PSC, max( MDAPS_MAIS ) as MDAPS_MAIS, max( NAICS ) as NAICS, max( PRGM_CODE ) as PRGM_CODE, max( ACCP_ADD_CODE ) as ACCP_ADD_CODE, max( ACCP_ADD_DTLS ) as ACCP_ADD_DTLS, max( ACCP_ADD_LOC ) as ACCP_ADD_LOC, max( ACCP_LOC ) as ACCP_LOC, max( INSP_ADD_CODE ) as INSP_ADD_CODE, max( INSP_ADD_LOC ) as INSP_ADD_LOC, max( INSP_LEVEL ) as INSP_LEVEL, max( INSP_LOC ) as INSP_LOC, max( INSP_LOC_ADD ) as INSP_LOC_ADD, max( INSP_RESP ) as INSP_RESP, max( ADD_MARK_TXT ) as ADD_MARK_TXT, max( CHRG_SHIP_TO ) as CHRG_SHIP_TO, max( FOB ) as FOB, max( HAZMAT ) as HAZMAT, max( MILSTRIP ) as MILSTRIP, max( PREC_MTL_CODE ) as PREC_MTL_CODE, max( SHIP_MODE ) as SHIP_MODE, max( SHIP_TO_ADDR ) as SHIP_TO_ADDR, max( SHIP_TO_CNT ) as SHIP_TO_CNT, max( TRNSP_CTR_NUM ) as TRNSP_CTR_NUM, max( TRNSP_PRIOR ) as TRNSP_PRIOR, max( hiddShipAddXml ) as hiddShipAddXml, max( hiddenCountry ) as hiddenCountry, max( hiddenZipCode ) as hiddenZipCode from (  SELECT gt.char1 ECC_SPEC_ID     , .DRAWING_NUM as DRAWING_NUM , .EXTND_DESC as EXTND_DESC , .MANF_NAME as MANF_NAME , .MANF_PART_NUM as MANF_PART_NUM , .MODEL_NUM as MODEL_NUM , .NSN as NSN , .PIECE_NUM as PIECE_NUM , .PR_CT_NUM as PR_CT_NUM , .SERIAL_NUM as SERIAL_NUM , .SPEC_NUM as SPEC_NUM , .VND_PRT_NUM as VND_PRT_NUM , .AWARD_FEE as AWARD_FEE , .TOTAL_AMOUNT as TOTAL_AMOUNT , .QUANTITY as QUANTITY , .UOM_DISP as UOM , .BASE_FEE as BASE_FEE , .ESTIMATED_COST as ESTIMATED_COST , .FIXED_FEE as FIXED_FEE , .FIXED_FEE_PER as FIXED_FEE_PER , .MAXIMUM_COST as MAXIMUM_COST , .GOVT_SH_AB_TARGET as GOVT_SH_AB_TARGET , .GOVT_SH_BE_TARGET as GOVT_SH_BE_TARGET , .MAXIMUM_FEE as MAXIMUM_FEE , .MINIMUM_FEE as MINIMUM_FEE , .TARGET_COST as TARGET_COST , .TARGET_FEE as TARGET_FEE , .CONT_SH_AMOUNT as CONT_SH_AMOUNT , .GOVT_SHARE_PER as GOVT_SHARE_PER , .GOVT_SH_AMOUNT as GOVT_SH_AMOUNT , .UNIT_PRICE as UNIT_PRICE , .MINIMUM_QUANTITY as MINIMUM_QUANTITY , .CEILING_PRICE as CEILING_PRICE , .CEILING_PRICE_PER as CEILING_PRICE_PER , .TARGET_PROFIT as TARGET_PROFIT , .TAR_UNIT_PRICE as TAR_UNIT_PRICE , .TOT_TAR_PRICE as TOT_TAR_PRICE , .CEIL_FTP as CEIL_FTP , .FLOOR_FTP as FLOOR_FTP , .MINIMUM_HOURS as MINIMUM_HOURS , .DIRECT_COSTS as DIRECT_COSTS , .MAXIMUM_PRICE as MAXIMUM_PRICE , .MAXIMUM_QTY as MAXIMUM_QTY , .CUST_PRJ_CODE_DISP as CUST_PRJ_CODE , .CUST_PRJ_TXT as CUST_PRJ_TXT , .FSC_PSC_DISP as FSC_PSC , .MDAPS_MAIS_DISP as MDAPS_MAIS , .NAICS_DISP as NAICS , .PRGM_CODE_DISP as PRGM_CODE , .ACCP_ADD_CODE_DISP as ACCP_ADD_CODE , .ACCP_ADD_DTLS as ACCP_ADD_DTLS , .ACCP_ADD_LOC_DISP as ACCP_ADD_LOC , .ACCP_LOC_DISP as ACCP_LOC , .INSP_ADD_CODE_DISP as INSP_ADD_CODE , .INSP_ADD_LOC_DISP as INSP_ADD_LOC , .INSP_LEVEL as INSP_LEVEL , .INSP_LOC_DISP as INSP_LOC , .INSP_LOC_ADD as INSP_LOC_ADD , .INSP_RESP_DISP as INSP_RESP , .ADD_MARK_TXT as ADD_MARK_TXT , .CHRG_SHIP_TO as CHRG_SHIP_TO , .FOB_DISP as FOB , .HAZMAT_DISP as HAZMAT , .MILSTRIP as MILSTRIP , .PREC_MTL_CODE_DISP as PREC_MTL_CODE , .SHIP_MODE_DISP as SHIP_MODE , .SHIP_TO_ADDR as SHIP_TO_ADDR , .SHIP_TO_CNT_DISP as SHIP_TO_CNT , .TRNSP_CTR_NUM as TRNSP_CTR_NUM , .TRNSP_PRIOR as TRNSP_PRIOR , .hiddShipAddXml as hiddShipAddXml , .hiddenCountry as hiddenCountry , .hiddenZipCode as hiddenZipCode FROM po_session_gt gt  , PO_REQ_LINES_EXT_B ext  WHERE  gt.key =  3197938 AND ext.requisition_line_id(+) = gt.index_num2 and gt.index_num2 is not null ) group by ecc_spec_id
) x
where
2=2
Download
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: