DBA Data[Home] [Help]

APPS.WIP_EXPLODE_PHANTOM_RTGS dependencies on WIP_OPERATIONS

Line 709: FROM WIP_OPERATIONS

705: * ----------------------------------------------------------*/
706:
707: SELECT first_unit_start_date, last_unit_completion_date
708: INTO x_start_date, x_completion_date
709: FROM WIP_OPERATIONS
710: WHERE wip_entity_id = p_wip_entity_id
711: AND organization_id = p_org_id
712: and NVL(repetitive_schedule_id, -1) =
713: DECODE(p_entity_type, WIP_CONSTANTS.REPETITIVE, p_sched_id,-1)