Duplicate records while fetching end customer order details from internal sales order
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