Order Management - EBS (MOSC)

MOSC Banner

Duplicate records while fetching end customer order details from internal sales order

edited Jun 4, 2019 7:27AM in Order Management - EBS (MOSC) 2 commentsAnswered ✓

Hello experts,

Oracle Apps: 12.2.4

Oracle DB:11.2.04

we are trying to get insert end customer order details from ISO but it's inserting duplicate records into staging table.

Pseudo code:

Declare

/* to find released job details */

cursor  c1 is

select * from

FROM wip_discrete_jobs wdj,

                mfg_lookups ml,

                mfg_lookups ml2,

                wip_entities we,

                mtl_system_items msi,

                mtl_system_items_tl t,

                xxwip_test xx

where

...

...

AND ml.meaning = 'Released'

                AND ml.lookup_type = 'WIP_JOB_STATUS'

...

AND ml2.lookup_type = 'WIP_DISCRETE_JOB'

AND ml2.meaning = 'Standard'

                AND msi.inventory_item_id = t.inventory_item_id

                AND msi.organization_id = t.organization_id

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