[Home] [Help]
View: CE_PAY_FC_PAYROLL_V
Product: | CE - Cash Management |
Description: | Forecasting source - payroll expenses |
Implementation/DBA Data: |
APPS.CE_PAY_FC_PAYROLL_V
|
View Text
SELECT ACTION.BUSINESS_GROUP_ID
, /* 1 */ METHOD.CURRENCY_CODE
, /* 2 */ (PREPAY.VALUE)
, /* 3 */ PREPAY.BASE_CURRENCY_VALUE
, /* 4 */ ACTION.EFFECTIVE_DATE
, /* 5 */ METHOD.ORG_PAYMENT_METHOD_ID
, /* 6 */ METHOD.EXTERNAL_ACCOUNT_ID
, /* 7 */ BAU.BANK_ACCOUNT_ID
, /* 8 */ ACTION.PAYROLL_ID
, /* 9 */ ACTION.EFFECTIVE_DATE
, /* 10 */ METHOD.ORG_PAYMENT_METHOD_NAME
, /* 11 */ PREPAY.PRE_PAYMENT_ID /* 12 */ FROM PAY_PRE_PAYMENTS PREPAY
, PAY_ORG_PAYMENT_METHODS_F METHOD
, PAY_PAYROLL_ACTIONS ACTION
, PAY_ASSIGNMENT_ACTIONS ASGN
, CE_BANK_ACCT_USES_ALL BAU WHERE ACTION.ACTION_TYPE IN ('P'
, 'U'
, 'E') AND METHOD.ORG_PAYMENT_METHOD_ID = PREPAY.ORG_PAYMENT_METHOD_ID AND PREPAY.ASSIGNMENT_ACTION_ID = ASGN.ASSIGNMENT_ACTION_ID AND ASGN.PAYROLL_ACTION_ID = ACTION.PAYROLL_ACTION_ID AND ACTION.EFFECTIVE_DATE BETWEEN METHOD.EFFECTIVE_START_DATE AND METHOD.EFFECTIVE_END_DATE AND METHOD.EXTERNAL_ACCOUNT_ID = BAU.PAYROLL_BANK_ACCOUNT_ID
Columns
Name |
ORG_ID |
CURRENCY_CODE |
AMOUNT |
BASE_AMOUNT |
EFFECTIVE_DATE |
ORG_PAYMENT_METHOD_ID |
PAYROLL_BANK_ACCOUNT_ID |
BANK_ACCOUNT_ID |
PAYROLL_ID |
TRX_DATE |
PAYMENT_METHOD |
REFERENCE_ID |