Name |
Descriptive Flex |
Display |
Insert |
Update |
Default Type |
Default Value |
Shared Name |
ATTRIBUTE1 |
$SRS$.PARRGLBB_FORECASTS |
N |
N |
N | S | SELECT FND_DATE.DATE_TO_DISPLAYDATE(per1.start_date) FROM gl_periods per1 WHERE per1.period_num = 1 AND (per1.period_set_name, per1.period_type, per1.period_year) IN (SELECT per.period_set_name, per.period_type, per.period_year FROM gl_periods per, pa_implementations i, gl_sets_of_books sob WHERE sob.set_of_books_id = i.set_of_books_id AND per.period_set_name = sob.period_set_name AND per.period_type = sob.accounted_period_type AND per.adjustment_period_flag = 'N' AND TRUNC(sysdate) between per.start_date and per.end_date) | p_ac_start_date |
ATTRIBUTE2 |
$SRS$.PARRGLBB_FORECASTS |
Y |
Y |
Y | | | p_ac_end_date |
ATTRIBUTE3 |
$SRS$.PARRGLBB_FORECASTS |
N |
N |
N | S | SELECT FND_DATE.DATE_TO_DISPLAYDATE(per1.start_date) FROM gl_periods per1 WHERE per1.period_num = 1 AND (per1.period_set_name, per1.period_type, per1.period_year) IN (SELECT per.period_set_name, per.period_type, per.period_year FROM gl_periods per, pa_implementations i, gl_sets_of_books sob WHERE sob.set_of_books_id = i.set_of_books_id AND per.period_set_name = sob.period_set_name AND per.period_type = sob.accounted_period_type AND per.adjustment_period_flag = 'N' AND TRUNC(sysdate) between per.start_date and per.end_date) | p_fc_start_date |
ATTRIBUTE4 |
$SRS$.PARRGLBB_FORECASTS |
Y |
Y |
Y | | | p_fc_end_date |
ATTRIBUTE5 |
$SRS$.PARRGLBB_FORECASTS |
N |
N |
N | S | SELECT meaning FROM pa_lookups WHERE lookup_type = 'PA_REP_UTIL_ORG_ROLLUP_METHOD' AND lookup_code = 'I' | p_org_rollup_method |
ATTRIBUTE6 |
$SRS$.PARRGLBB_FORECASTS |
N |
N |
N | P | PA_DEBUG_MODE | p_debug_mode |