Oracle Financial Important tables, links, ER Diagram










Comments

Post a Comment

Popular posts from this blog

API Procedure to inactive Items in oracle apps

--API to update the item status. /**** STEP 1) Insert data into pending interface table ****/ insert into mtl_pending_item_status           (inventory_item_id,           organization_id,           status_code,           effective_date,           implemented_date,           pending_flag,           last_update_date,           last_updated_by,           creation_date,           created_by)      values(          6760202,   -- Item Segment           114,   -- Organization Id           'Inactive',  -- status           sysdate,           sysdate,     ...
Read more

API To update Oracle Items

/* Formatted on 2018/04/23 12:05 (Formatter Plus v4.8.8) */ DECLARE    v_po_qty              NUMBER;    v_so_qty              NUMBER;    v_oh_qty              NUMBER;    b_has_backlog         BOOLEAN;    v_po_number           VARCHAR2 (40);    v_po_line_num         VARCHAR2 (40);    v_so_order_number     VARCHAR2 (40);    v_so_ine_number       VARCHAR2 (40);    v_subinventory_code   VARCHAR2 (40);    x_inventory_item_id   NUMBER;    x_organization_id     NUMBER;    x_return_status       VARCHAR2 (3000);    x_msg_count           NUMBER;   ...
Read more