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