Employee Category is a lookup. the value that is in per_all_assignments_f for employee_category is the lookup_code that is stored.
FND_COMMON_LOOKUPS has the column lookup_type with value 'EMP_CAT' and column lookup_code is the value in per_all_assignments_f
and meaning is value seen in the front end. query the table fnd_common_lookups where lookup_type = 'EMP_CAT'
and you will understand. you can also query the quickcodes window from hrms resp in front end for 'employment category' value.
EMPLOYEE_CATEGORY holds in the table *PER_ALL_ASSIGNMENTS_F
Developers in 11i/R12 EBS are in a race with the Universe to create better idiot-proof programs, while the Universe is trying to create better idiots. So far the Universe is winning.
Recent Posts
Categories
AIM
(3)
AOL
(23)
AP
(15)
API
(14)
AR
(19)
CE
(1)
DFF
(1)
EAM
(1)
Enterprises Model
(6)
FA
(18)
GL
(10)
How
(15)
HRMS
(19)
IB
(1)
Info
(11)
INV
(5)
Issue
(1)
Locking
(2)
Misc
(1)
More4Apps
(1)
OE
(2)
OKC
(2)
OKE
(1)
OKS
(4)
OM
(4)
Oracle
(3)
Oracle Applications
(10)
Oracle Price Lists
(1)
Oracle Product
(1)
Payroll
(2)
PJM
(1)
PO
(7)
Project Accounting
(2)
Query
(96)
R12
(5)
Reconcilation
(2)
Sample
(1)
WorkFlow
(2)
WSH
(6)
Social Profiles
-
SELECT PAPF.PERSON_ID, PAPF.FIRST_NAME AS FIRST_NAME, PAPF.LAST_NAME AS LAST_NAME, PAPF.EMPLOYEE_NUMBER AS EMPLOYEE_NUMBER, TO_CHAR(PAPF...
-
SELECT (SELECT sob.NAME FROM gl.gl_sets_of_books sob WHERE sob.set_of_books_id = a.set_of_books_id) "SOB_Nam...
-
SELECT PAAF.ASSIGNMENT_ID, PAPF.PERSON_ID AS PERSON_ID2, PAPF.FIRST_NAME AS FIRST_NAME, PAPF.LAST_NAME AS LAST_NAME, PAPF.EMAIL_ADDRESS...
-
select secondary_inventory_name subinventory, description, subinventory_type, organization_id, asset_inventory, quan...
-
If you want to enable the DFF and enter some additional entries in Lookups you just need to follow the below steps STEPS FOR YOU: Creat...
-
select * from hr_locations_v hlv, hr_all_organization_units hou WHERE hlv.inventory_organization_id = hou.organization_id AND hlv.locatio...
-
SELECT distinct c.customer_name, c.customer_number, c.customer_id, t.customer_trx_id, t.trx_number, ct.NAME invoice_type, l.line_numbe...
-
SELECT OHA.ORDER_NUMBER, HS.HOLD_ENTITY_CODE CREDIT_CHECK_CRITERIA_CODE, FLV.MEANING CREDIT_CHECK_CRITERIA, HD.NAME ...
-
Relation between Order Number (From Order Management) and Contract Number (From Service Contracts module). The relationship is maintained ...
-
SELECT wnd.delivery_id, ...
Blog Archive
-
▼
2010
(120)
-
▼
August
(109)
- INFO: Oracle Workflow APIs
- Query : To get the Statement of expenses incurred ...
- Query : INTRANSIT REPORT
- INFO: AIM Documents for Techies & Techno Functional
- Query : Asset migration
- Query :
- Query : To get Prepayment Invoice Status
- INFO: Accounting lines in FA via SLA
- Query : To get YTD Depreciation
- Query : Get the Inventory org Address
- Query : To get the list of Custom Alerts
- Query : Retrieve Incomplete Invoices before month end
- Query : To retrieve transactions with a certain am...
- Query : To validate whether a transaction's REC is...
- How : Amortized and Expensed Adjustments
- Query : To query Receipt Accounting entries -II
- Query : To query Receipt Accounting entries -I
- Query : To Check whether Periods of AP/AR/GL/FA/PO...
- Query : Verify that Multi Org is Installed
- Query : Sales Order Hold & Release
- Query : Get the Account Description
- Query : Get Inventory Accounting Entries linked to GL
- How : General Ledger and Accounts Payabels connect...
- Query : AP to GL data transfer
- Query : Subledger Transfer to GL
- How : What are the tables involved in the Transfer...
- Query : Drilldown from GL to Receiving Transactions
- Query : Lists all the organization units in the sy...
- Query : To get the asset detail information
- Query : Check responsibility assigned to a specifi...
- Query : To get all request with application
- Query : To get assigned responsibility to a user
- Query : Get the Hierarchial Information
- Query : INVENTORY & ORDER MANAGEMENT
- Setting Organization Context in Oracle R12
- Oracle Price Lists
- EAM
- How : Item Import
- Query to find subinventories for an inv organization
- Query to find organization parameters of an inv org
- Query to find Supplier sites
- Query to find supplier info
- Shipping APIs
- Query to find delivery leg and pick up stop info
- Query to find Bill of Lading info of the Delivery
- Query to find out Move order line details
- Query : AR to GL data transfer
- Query : to find out the shipper info :
- Query : To find PO returns
- API: ORACLE SERVICE CONTRACT API’S
- API : User Creation
- Query : Purchase Order and Requisition
- Query : Customer Listing with Bill To and Ship To ...
- Query : To find an PO details
- HOW: Contract Line Created in OKS
- Query : Retrieve ex employees for last 3 months
- Query : Finding Subordinates and their subordinates
- Query : Find employee count
- Data Mapping from Payroll to General Ledger when i...
- Sample Code: For warranty contract creation for In...
- How : Payroll is moved to GL
- Query : Relation between Order Number & Contract N...
- API : Contracts Migration API
- Service contracts API
- Salary History Conversion
- How to create a report for various payroll runs
- Interface from OTL to 3rd party payroll provider
- Query : To get Active Employees and Terminated Emp...
- INFO: EMPLOYEE_CATEGORY holds in the table *PER_AL...
- Query : Job Change Date
- API to use to update employee additional attributes
- How to Purge Employee Record
- Query : Query to get Person type for All Employees
- API for loading qualification subjects on R12.1
- Where is documentation for EBS API's
- Automatically populate a Descriptive FlexField wit...
- How to :Oracle Apps Concurrent Program : Host: pro...
- How to Know Concurrent Program finishes
- FND_USER_PKG
- Query : Get Bank Information from HZ Tables
- Query : Get assets category list
- GL Tables which stores parent and child segments i...
- Query :Operating Unit name based on the Operating ...
- Query : Flexfields avilable for your Oracle Applic...
- Query: AR Query to get open invoices for single/Al...
- Query: To find Oracle API's for any module
- Query :Requisition Number from PO Number
- Confusion World: Examples of the to_date function
- Diff bet ad_bugs and ad_appiled_patches tables
- Query : Find the responsibilty for which form was ...
- VLOOKUP function in M.S. Excel with example
- Query: To find Patch Level for a product searching...
- Query:Responsibility assigned to a specific USER
- Query :Responsibility and attached request groups
- Query : Active Alert information
- Query :Employee Contact Information
- Query : Responsibility to a Set of Books in Oracle
- QUERY: Which Oracle Apps Version i am using
- Query to List all the responsibilities attached to...
- ssss
-
▼
August
(109)
Text Widget
Download
Developers in 11i/R12 EBS are in a race with the Universe to create better idiot-proof programs, while the Universe is trying to create better idiots. So far the Universe is winning..
0 comments:
Post a Comment