Product: | FII - Financial Intelligence |
---|---|
Description: | FIIBV_AP_AP_APPY_PYMT_MTHD_LCV is the base view for Payment Method level of AP Payment dimension |
Implementation/DBA Data: | APPS.FIIBV_AP_AP_APPY_PYMT_MTHD_LCV |
SELECT LC.LOOKUP_CODE PAYMENT_METHOD_PK
, 'ALL' ALL_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, LC.DISPLAYED_FIELD NAME
, LC.DISPLAYED_FIELD PAYMENT_METHOD
, LC.DESCRIPTION DESCRIPTION
, NVL(LC.START_DATE_ACTIVE
, SYSDATE-1) LAST_UPDATE_DATE
, NVL(LC.START_DATE_ACTIVE
, SYSDATE-1) CREATION_DATE
, NULL DELETION_DATE
, NULL PAYMENT_METHOD_DP
, '_DF:FND:FND_COMMON_LOOKUPS:FND'
, '_DF:_DUMMY:SQLAP:AP_CHECKS:AC'
, '_DF:_DUMMY:SQLAP:CHECK ADDRESS:AC'
, '_DF:_DUMMY:SQLAP:AP_GOV_DETAIL_CHECKS:AC'
, '_DF:_DUMMY:JG:JG_AP_CHECKS:AC'
FROM AP_LOOKUP_CODES LC
, FND_LOOKUP_VALUES FND
WHERE LC.LOOKUP_TYPE = 'PAYMENT METHOD'
AND LC.LOOKUP_TYPE=FND.LOOKUP_TYPE
AND LC.LOOKUP_CODE=FND.LOOKUP_CODE
AND LC.DISPLAYED_FIELD=FND.MEANING