DBA Data[Home] [Help]

APPS.CSTPSMUT dependencies on WIP_ENTITIES

Line 4263: wip_entities we

4259: p_sm_txn_id
4260: FROM
4261: mtl_transaction_types mtt,
4262: mtl_system_items msi,
4263: wip_entities we
4264: WHERE we.wip_entity_id = p_wip_entity_id
4265: AND we.primary_item_id = msi.inventory_item_id
4266: AND we.organization_id = msi.organization_id
4267: AND mtt.transaction_action_id = p_action_id

Line 4355: FROM wip_entities we

4351: we.organization_id, we.wip_entity_id, p_acct_period_id,
4352: p_lookup_code, p_date, p_operation_seq_num,
4353: p_sm_txn_id, l_txn_uom, l_pr_uom,
4354: we.primary_item_id
4355: FROM wip_entities we
4356: WHERE we.wip_entity_id = p_wip_entity_id
4357: AND exists
4358: ( SELECT null
4359: FROM wip_transaction_accounts