DBA Data[Home] [Help]

APPS.CSD_RULES_ENGINE_PVT dependencies on WIP_ENTITIES

Line 30: FROM mtl_item_categories mic,wip_entities we

26: BEGIN
27: BEGIN
28: SELECT fnd_api.g_true
29: INTO l_return_val
30: FROM mtl_item_categories mic,wip_entities we
31: WHERE mic.inventory_item_id = p_mtl_txn_item_id
32: AND mic.category_id = p_criterion
33: AND mic.organization_id = we.organization_id
34: AND we.wip_entity_id = p_wip_entity_id;

Line 1669: FROM wip_entities we, org_organization_definitions orgv,

1665: SELECT we.primary_item_id,
1666: we.organization_id,
1667: hrla.country,
1668: orgv.operating_unit
1669: FROM wip_entities we, org_organization_definitions orgv,
1670: PER_ORGANIZATION_UNITS porg, hr_locations_all hrla
1671: WHERE we.wip_entity_id = p_wip_entity_id
1672: and we.organization_id = orgv.organization_id
1673: and we.organization_id = porg.organization_id