Table: PSA_OPTION_DETAILS_GT | Oracle EBS ETRM Search

Table: PSA_OPTION_DETAILS_GT 12.1.1

owner PSA·PSA - Public Sector Financials·9 columns

This table is created to improve performance of funds checker. It is populated with the budgetary control parameters for each packet, journal source and journal category which are later used by funds checker during budgetary control process

PSA.PSA_OPTION_DETAILS_GT·Explore PSA module →

View: PQP_PROFESSIONAL_BODY_TEMP_V 12.2.2

PQP - Public Sector Payroll·19 columns

View of all base elements created by the professional body element template.

APPS.PQP_PROFESSIONAL_BODY_TEMP_V·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ORGANIZATION_INFORMATION·Explore PQP module →

Table: PSA_OPTION_DETAILS_GT 12.2.2

owner PSA·PSA - Public Sector Financials·9 columns

This table is created to improve performance of funds checker. It is populated with the budgetary control parameters for each packet, journal source and journal category which are later used by funds checker during budgetary control process

PSA.PSA_OPTION_DETAILS_GT·Explore PSA module →

Table: GL_BC_OPTION_DETAILS 12.1.1 link

owner GL·GL - General Ledger·28 columns

Budgetary control option details

GL.GL_BC_OPTION_DETAILS·Explore GL module →

Table: GL_BC_OPTION_DETAILS 12.2.2 link

owner GL·GL - General Ledger·28 columns

Budgetary control option details

GL.GL_BC_OPTION_DETAILS·Explore GL module →

View: PAY_CA_EMP_ALL_PROVTAX_INFO_V 12.1.1

PAY - Payroll·30 columns

APPS.PAY_CA_EMP_ALL_PROVTAX_INFO_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →

View: GL_BC_OPTION_DETAILS_V 12.1.1

GL - General Ledger·32 columns

10SC ONLY

APPS.GL_BC_OPTION_DETAILS_V·↳ GL_BC_OPTION_DETAILS·↳ GL_JE_CATEGORIES·↳ GL_JE_SOURCES·Explore GL module →

View: HR_ADP_CITY_TAX_V 12.1.1

PER - Human Resources·34 columns

ADP payroll interface view

APPS.HR_ADP_CITY_TAX_V·↳ FND_GLOBAL·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·Explore PER module →

View: PQP_PROFESSIONAL_BODY_TEMP_V 12.1.1

PQP - Public Sector Payroll·19 columns

View of all base elements created by the professional body element template.

APPS.PQP_PROFESSIONAL_BODY_TEMP_V·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ORGANIZATION_INFORMATION·Explore PQP module →

View: PQP_UNION_TEMPLATE_V 12.2.2

PQP - Public Sector Payroll·23 columns

View of all base elements created by the union deductions element template.

APPS.PQP_UNION_TEMPLATE_V·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_API·Explore PQP module →

View: PQP_UNION_TEMPLATE_V 12.1.1

PQP - Public Sector Payroll·23 columns

View of all base elements created by the union deductions element template.

APPS.PQP_UNION_TEMPLATE_V·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PQP module →

View: OKS_K_LINES_V 12.2.2

OKS - Service Contracts·107 columns

Service Contracts Line Attributes

APPS.OKS_K_LINES_V·↳ OKS_K_LINES_B·↳ OKS_K_LINES_TL·Explore OKS module →

View: HR_ADP_FED_TAX_V 12.1.1

PER - Human Resources·29 columns

ADP payroll interface view

APPS.HR_ADP_FED_TAX_V·↳ FND_GLOBAL·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·Explore PER module →

View: HR_ADP_FED_TAX_V 12.2.2

PER - Human Resources·29 columns

ADP payroll interface view

APPS.HR_ADP_FED_TAX_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →

View: GL_BC_OPTION_DETAILS_V 12.2.2

GL - General Ledger·32 columns

10SC ONLY

APPS.GL_BC_OPTION_DETAILS_V·↳ GL_BC_OPTION_DETAILS·↳ GL_JE_CATEGORIES·↳ GL_JE_SOURCES·Explore GL module →

View: PAY_CA_EMP_ALL_PROVTAX_INFO_V 12.2.2

PAY - Payroll·30 columns

APPS.PAY_CA_EMP_ALL_PROVTAX_INFO_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →

View: HR_ADP_STATE_TAX_V 12.1.1

PER - Human Resources·35 columns

ADP payroll interface view

APPS.HR_ADP_STATE_TAX_V·↳ FND_GLOBAL·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·Explore PER module →

View: OKS_AUTH_LINES_HV 12.2.2

OKS - Service Contracts·196 columns

APPS.OKS_AUTH_LINES_HV·↳ OKC_K_LINES_BH·↳ OKC_K_LINES_TLH·↳ OKS_K_LINES_BH·Explore OKS module →

View: HR_ADP_CITY_TAX_V 12.2.2

PER - Human Resources·34 columns

ADP payroll interface view

APPS.HR_ADP_CITY_TAX_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →

View: HR_ADP_STATE_TAX_V 12.2.2

PER - Human Resources·35 columns

ADP payroll interface view

APPS.HR_ADP_STATE_TAX_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →

Table: OKS_K_LINES_BH 12.1.1 standalone

owner OKS·OKS - Service Contracts·97 columns

Service Contracts Line Attributes History

OKS.OKS_K_LINES_BH·Explore OKS module →

View: GL_BC_PACKETS_V 12.1.1

GL - General Ledger·80 columns

10SC ONLY

APPS.GL_BC_PACKETS_V·↳ GL_BC_PACKETS·↳ GL_BUDGET_VERSIONS·↳ GL_ENCUMBRANCE_TYPES·Explore GL module →

Table: GL_BC_PACKETS 12.2.2 link

owner GL·GL - General Ledger·89 columns

Budgetary control queue table

GL.GL_BC_PACKETS·Explore GL module →

Table: GL_BC_PACKETS_HISTS 12.2.2 link

owner GL·GL - General Ledger·89 columns

GL_BC_PACKETS_HISTS is Oracle General Ledger's history table for the Budgetary Control feature. This table stores the budgetary control packets that are deleted from table GL_BC_PACKETS.

GL.GL_BC_PACKETS_HISTS·Explore GL module →

View: OKS_K_LINES_V 12.1.1

OKS - Service Contracts·105 columns

Service Contracts Line Attributes

APPS.OKS_K_LINES_V·↳ OKS_K_LINES_B·↳ OKS_K_LINES_TL·Explore OKS module →

View: OKS_K_LINES_HV 12.2.2

OKS - Service Contracts·104 columns

Service Contracts Line Attributes History

APPS.OKS_K_LINES_HV·↳ OKS_K_LINES_BH·↳ OKS_K_LINES_TLH·Explore OKS module →

View: OKS_K_LINES_HV 12.1.1

OKS - Service Contracts·103 columns

Service Contracts Line Attributes History

APPS.OKS_K_LINES_HV·↳ OKS_K_LINES_BH·↳ OKS_K_LINES_TLH·Explore OKS module →

View: OKS_AUTH_LINES_HV 12.1.1

OKS - Service Contracts·195 columns

APPS.OKS_AUTH_LINES_HV·↳ OKC_K_LINES_BH·↳ OKC_K_LINES_TLH·↳ OKS_K_LINES_BH·Explore OKS module →

View: OKS_AUTH_LINES_V 12.1.1

OKS - Service Contracts·194 columns

APPS.OKS_AUTH_LINES_V·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·↳ OKS_K_LINES_B·Explore OKS module →

View: GL_BC_PACKETS_V 12.2.2

GL - General Ledger·80 columns

10SC ONLY

APPS.GL_BC_PACKETS_V·↳ GL_BC_PACKETS·↳ GL_BUDGET_VERSIONS·↳ GL_ENCUMBRANCE_TYPES·Explore GL module →

View: OKS_AUTH_LINES_V 12.2.2

OKS - Service Contracts·195 columns

APPS.OKS_AUTH_LINES_V·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·↳ OKS_K_LINES_B·Explore OKS module →

Table: GL_BC_PACKETS_HISTS 12.1.1 link

owner GL·GL - General Ledger·89 columns

GL_BC_PACKETS_HISTS is Oracle General Ledger's history table for the Budgetary Control feature. This table stores the budgetary control packets that are deleted from table GL_BC_PACKETS.

GL.GL_BC_PACKETS_HISTS·Explore GL module →

Table: OKS_K_LINES_BH 12.2.2 standalone

owner OKS·OKS - Service Contracts·99 columns

Service Contracts Line Attributes History

OKS.OKS_K_LINES_BH·Explore OKS module →

Table: OKS_K_LINES_B 12.1.1 standalone

owner OKS·OKS - Service Contracts·99 columns

Service Contracts Line Attributes

OKS.OKS_K_LINES_B·Explore OKS module →

Table: GL_BC_PACKETS 12.1.1 link

owner GL·GL - General Ledger·89 columns

Budgetary control queue table