DBA Data[Home] [Help]

APPS.CST_OSFMUPGRADE_PVT dependencies on WIP_DISCRETE_JOBS

Line 73: FROM wip_entities we, wip_discrete_jobs wdj

69: UPDATE wip_requirement_operations wro
70: SET costed_quantity_issued = NVL(quantity_issued,0),
71: costed_quantity_relieved = NVL(quantity_relieved,0)
72: WHERE exists ( SELECT 1
73: FROM wip_entities we, wip_discrete_jobs wdj
74: WHERE we.wip_entity_id = wro.wip_entity_id
75: AND we.organization_id = wro.organization_id
76: AND we.entity_type = 5
77: AND we.wip_entity_id = wdj.wip_entity_id

Line 88: FROM wip_entities we, wip_discrete_jobs wdj

84: SET costed_quantity_issued = NVL(quantity_issued,0),
85: costed_quantity_relieved = NVL(quantity_relieved,0)
86: WHERE wro.organization_id = p_organization_id
87: AND exists ( SELECT 1
88: FROM wip_entities we, wip_discrete_jobs wdj
89: WHERE we.wip_entity_id = wro.wip_entity_id
90: AND we.organization_id = wro.organization_id
91: AND we.entity_type = 5
92: AND we.wip_entity_id = wdj.wip_entity_id