DBA Data[Home] [Help]

APPS.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on WIP_REPETITIVE_SCHEDULES

Line 1618: FROM WIP_REPETITIVE_SCHEDULES WRS

1614: l_user_id, SYSDATE,
1615: l_user_id, l_login_id,
1616: p_org_hierarchy_origin, 2,
1617: 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1618: FROM WIP_REPETITIVE_SCHEDULES WRS
1619: WHERE WRS.STATUS_TYPE IN (3, 4, 6)
1620: AND WRS.ORGANIZATION_ID = p_org_hierarchy_origin
1621: AND ((WRS.CREATION_DATE between l_start_time and l_end_time)
1622: or (WRS.DATE_RELEASED between l_start_time and l_end_time))

Line 2076: FROM WIP_REPETITIVE_SCHEDULES WRS

2072: l_user_id, SYSDATE,
2073: l_user_id, l_login_id,
2074: l_orgid, 2,
2075: 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2076: FROM WIP_REPETITIVE_SCHEDULES WRS
2077: WHERE WRS.STATUS_TYPE IN (3, 4, 6)
2078: AND WRS.ORGANIZATION_ID = l_orgid
2079: AND ((WRS.CREATION_DATE between l_start_time and l_end_time)
2080: or (WRS.DATE_RELEASED between l_start_time and l_end_time))