Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

Using API BOMPXINQ.Export_BOM

edited Jul 31, 2009 5:15AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 2 commentsAnswered
Hi

  We are planning to use API BOMPXINQ.Export_BOM for exploding BOM and use temp table (BOM_SMALL_EXPL_TEMP) to extract levels

PROCEDURE Export_BOM  ( Profile_id      IN   NUMBER ,
                        Org_hierarchy_name     IN  VARCHAR2,
                        Assembly_item_id  IN NUMBER,
                        Organization_id   IN NUMBER,
                        Alternate_bm_designator  IN VARCHAR2 DEFAULT '',
                        Costs    IN NUMBER DEFAULT 2,
                        Cost_type_id   IN NUMBER DEFAULT 0,
                        bom_export_tab   OUT NOCOPY bomexporttabtype,
                        Err_Msg    OUT NOCOPY VARCHAR2,
                        Error_Code   OUT NOCOPY NUMBER );

Among input parameters for profile_id and Org_hierarchy_name    how values can be derived from Oracle and pass to this API is there any setup for this

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center