PL-SQL Script for Approved Supplier List creation for item(s) In Oracle R12 using API po_asl_api_pub.create_update_asl
Category: R12
Item Assignment Script in Oracle R12
PL-SQL script to assign the items from one inventory org to another.
OE_ORDER_HEADERS_ALL: Column, Index & Few Tricks
OE_ORDER_HEADERS_ALL: The table used by Oracle Fusion to store the Sales Order Header level data. You would need to query OE_ORDER_HEADERS_ALL table if you have implemented O2C Cycle. So you can say that this is the equivalent of table DOO_HEADERS_ALL table in Oracle Fusion. In this post, we will discuss the columns and indexes present… Continue reading OE_ORDER_HEADERS_ALL: Column, Index & Few Tricks
Item Details Query in Oracle R12 to Fetch Imp Columns
Query ( SQL) to fetch the item details such as Item number, lead time, planner code, min max quantity in Oracle R12
MTL_PARAMETERS: Columns, Indexes & Few Tips
MTL_PARAMETERS: Table Structure, Indexes and a few salients points to brief the importance and usage of the table in Oracle R12.