| Value |
 Expression: "DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'SELECT
CAST(PO.FISCAL_YEAR + PO.REF_NBR as varchar(12)) as PurchaseOrderAK
,PO.FISCAL_YEAR as FiscalYear
,PO.REF_NBR as PurchaseOrderNumber
,CAST(ISNULL(PO.STATUS, 'N/A') AS VARCHAR(3)) as PoStatusCode
,ISNULL(StatusDesc.STATUS_DESC, 'N/A') as PoStatus
,ISNULL(CAST(PO.REC_STATUS AS VARCHAR(3)), 'N/A') as ReceivingStatusCode
,ISNULL(RecStatDesc.STATUS_DESC, 'N/A') as ReceivingStatus
,ISNULL(CAST(PO.PAY_STATUS AS VARCHAR(3)),'N/A') as PayStatusCode
,ISNULL(PayStatDesc.STATUS_DESC, 'N/A') as PayStatus
,ISNULL(CAST(PO.REF_TYPE AS VARCHAR(3)), 'N/A') as PoTypeCode
,ISNULL(RefTypesDesc.DESCRIPTION, 'N/A') as PoType
,ISNULL(PO.BUYER_ID, 'N/A') as BuyerId
,CAST(ISNULL(BuyerName.BUYER_NAME, 'N/A'
DECLARE @IncrementalBeginDtTm datetime = 'Jan 1 1900 12:00AM' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = 'Mar 4 2016 10:33AM'SELECT
CAST(PO.FISCAL_YEAR + PO.REF_NBR as varchar(12)) as PurchaseOrderAK
,PO.FISCAL_YEAR as FiscalYear
,PO.REF_NBR as PurchaseOrderNumber
,CAST(ISNULL(PO.STATUS, 'N/A') AS VARCHAR(3)) as PoStatusCode
,ISNULL(StatusDesc.STATUS_DESC, 'N/A') as PoStatus
,ISNULL(CAST(PO.REC_STATUS AS VARCHAR(3)), 'N/A') as ReceivingStatusCode
,ISNULL(RecStatDesc.STATUS_DESC, 'N/A') as ReceivingStatus
,ISNULL(CAST(PO.PAY_STATUS AS VARCHAR(3)),'N/A') as PayStatusCode
,ISNULL(PayStatDesc.STATUS_DESC, 'N/A') as PayStatus
,ISNULL(CAST(PO.REF_TYPE AS VARCHAR(3)), 'N/A') as PoTypeCode
,ISNULL(RefTypesDesc.DESCRIPTION, 'N/A') as PoType
,ISNULL(PO.BUYER_ID, 'N/A') as BuyerId
,CAST(ISNULL(BuyerName.BUYER_NAME, 'N/A') AS VARCHAR(30)) AS Buyer
FROM FIP_PO_HDR PO
LEFT OUTER JOIN UTL_CODE_TABLE RefTypesDesc
ON (
RefTypesDesc.TABLE_NAME = 'REF-TYPES'
AND RefTypesDesc.CODE = PO.REF_TYPE
AND RefTypesDesc.STATUS = 'A'
)
LEFT OUTER JOIN FIP_TABLES StatusDesc
ON (
StatusDesc.STATUS_CODE = PO.STATUS
)
LEFT OUTER JOIN FIP_TABLES RecStatDesc
ON (
RecStatDesc.STATUS_CODE = PO.REC_STATUS
)
LEFT OUTER JOIN FIP_TABLES PayStatDesc
ON (
PayStatDesc.STATUS_CODE = PO.PAY_STATUS
)
LEFT OUTER JOIN FIP_TABLES BuyerName
ON (
BuyerName.BUYER_ID = PO.BUYER_ID
)
WHERE (CAST(PO.FISCAL_YEAR + PO.REF_NBR as varchar(12))) IN
(
/* Select changed records from Student File */
SELECT CAST(FISCAL_YEAR + REF_NBR as varchar(12))
FROM FIP_PO_HDR
WHERE (
FIP_PO_HDR.RowUpdatedOn >= @IncrementalBeginDtTm
AND FIP_PO_HDR.RowUpdatedOn <= @IncrementalEndDtTm
)
)
|
| Expression |
"DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'SELECT
CAST(PO.FISCAL_YEAR + PO.REF_NBR as varchar(12)) as PurchaseOrderAK
,PO.FISCAL_YEAR as FiscalYear
,PO.REF_NBR as PurchaseOrderNumber
,CAST(ISNULL(PO.STATUS, 'N/A') AS VARCHAR(3)) as PoStatusCode
,ISNULL(StatusDesc.STATUS_DESC, 'N/A') as PoStatus
,ISNULL(CAST(PO.REC_STATUS AS VARCHAR(3)), 'N/A') as ReceivingStatusCode
,ISNULL(RecStatDesc.STATUS_DESC, 'N/A') as ReceivingStatus
,ISNULL(CAST(PO.PAY_STATUS AS VARCHAR(3)),'N/A') as PayStatusCode
,ISNULL(PayStatDesc.STATUS_DESC, 'N/A') as PayStatus
,ISNULL(CAST(PO.REF_TYPE AS VARCHAR(3)), 'N/A') as PoTypeCode
,ISNULL(RefTypesDesc.DESCRIPTION, 'N/A') as PoType
,ISNULL(PO.BUYER_ID, 'N/A') as BuyerId
,CAST(ISNULL(BuyerName.BUYER_NAME, 'N/A' |
Properties
