DBA Data[Home] [Help]

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on CSM_REQ_LINE_DETAILS_ACC

Line 1173: from CSM_REQ_LINE_DETAILS_ACC req_acc

1169: and b.last_update_date >= b_ret_acty_date
1170: and a.inventory_item_id=b.inventory_item_id
1171: and a.organization_id=nvl(b.receiving_inventory_org_id,b.issuing_inventory_org_id)) --return debrief-ed items
1172: and not exists(select 1
1173: from CSM_REQ_LINE_DETAILS_ACC req_acc
1174: where req_acc.user_id=au.user_id
1175: and req_acc.item_id=a.inventory_item_id
1176: and req_acc.org_id =a.organization_id) --htm5 user ordered/reserved item
1177: and not exists(select 1