DBA Data[Home] [Help]

APPS.CSTPOYLD dependencies on WIP_ENTITIES

Line 1163: WIP_ENTITIES we

1159: wdj.est_scrap_var_account,
1160: wdj.primary_item_id
1161: FROM WIP_COST_TXN_INTERFACE wcti,
1162: WIP_DISCRETE_JOBS wdj,
1163: WIP_ENTITIES we
1164: WHERE wcti.group_id = i_group_id
1165: AND we.entity_type = 5
1166: and we.wip_entity_id = wcti.wip_entity_id
1167: and we.organization_id = wcti.organization_id

Line 1829: wip_entities we

1825: AND transaction_type NOT IN (1, 2, 4, 5)
1826: GROUP BY wip_entity_id, operation_seq_num
1827: HAVING SUM((NVL(new_unit_cost,0) - NVL(old_unit_cost,0)) * adjustment_quantity) <> 0
1828: ) cscav,
1829: wip_entities we
1830: WHERE cscav.wip_entity = we.wip_entity_id
1831: AND we.organization_id = i_org_id
1832: AND we.entity_type = 5
1833: ORDER BY wip_entity, op_seq_num;