select HRL.COUNTRY, HROUTL_BG.name BG, HROUTL_BG.ORGANIZATION_ID, LEP.LEGAL_ENTITY_ID, LEP.name LEGAL_ENTITY, HROUTL_OU.name OU_NAME, HROUTL_OU.ORGANIZATION_ID ORG_ID, ...
Friday, June 27, 2014
SQL Query To Check Form Personalizations
SELECT ffcr.SEQUENCE "Seq", ffcr.description "Description",
DECODE (ffcr.rule_type,
'F', 'Form',
...
Key Tables in Oracle Inventory
TableDescription
MTL_PARAMETERSIt maintains a set of default options like general ledger accounts; locator, lot, and serial controls, inter-organization options, costing method, etc. for each organization...
FND Tables
FND_APPLICATION: Stores applications registered with Oracle Application Object
Library.
FND_APPLICATION_TL: Stores translated information about all the applications registered with...
Important Account Payables Tables
AP_SUPPLIERS:
This table replaces the old PO_VENDORS table.
It stores information about your supplier level attributes.
Each row includes the purchasing, receiving, invoice, tax,
classification,...
HZ tables in Oracle Receivables
I found this post very useful and found listed on many blogs so wanted to include here also for quick reference. This is not my original work.
HZ_PARTIES:
The HZ_PARTIES table stores basic...
Tuesday, June 24, 2014
Top Metalink Notes for Inventory
General
Note 123456.1: Latest 11i Applications Recommended Patch List
Note 568012.1: FAQ: Inventory Standard Datafixes
Note 438787.1: What are the events passed using Custom library and when do they...
Monday, June 23, 2014
Item Orderability Rules in Order Management
Item orderability is a new feature that Oracle introduced in order management release 12.1. Based on these rules, a user can restrict items that can be entered on sales order by manual or EDI, XML,...
Friday, June 20, 2014
Kanban
Definition : Kanban literally means signboard or billboard
in Japanese. It is first implemented at Toyota in 1953 and as per Wikipedia
"Kanban maintain inventory levels; a signal is sent to produce...
Subscribe to:
Posts (Atom)