DBA Data[Home] [Help]

APPS.CST_OSFMUPGRADE_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 69: UPDATE wip_requirement_operations wro

65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id : '||p_organization_id);
66:
67: IF (p_organization_id IS NULL) THEN
68: l_stmt_num := 30;
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

Line 83: UPDATE wip_requirement_operations wro

79: AND wdj.status_type NOT IN (1,12));
80:
81: ELSE
82: l_stmt_num := 40;
83: UPDATE wip_requirement_operations wro
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