DBA Data[Home] [Help]

APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 632: from wip_op_resource_instances

628: for update nowait;
629:
630: cursor c_WORI is
631: select 1
632: from wip_op_resource_instances
633: where wip_entity_id = p_wipEntityID
634: and organization_id = p_orgID
635: for update nowait;
636:

Line 1810: update wip_op_resource_instances

1806: ----------------------------------------------------------------
1807: l_stat_num := 130;
1808: --update resources instances (WORI)
1809: forall i in 1..l_cnt_wor
1810: update wip_op_resource_instances
1811: set start_date = NVL(x_resTbls.startDate(i), start_date),
1812: completion_date = NVL(x_resTbls.endDate(i), completion_date),
1813: ----standard who columns----
1814: last_update_date = l_sysdate,

Line 1963: wip_op_resource_instances wori

1959: l_progApplID,
1960: l_progID,
1961: l_sysdate
1962: from wip_operation_resource_usage woru,
1963: wip_op_resource_instances wori
1964: where woru.wip_entity_id = wori.wip_entity_id
1965: and woru.operation_seq_num = wori.operation_seq_num
1966: and woru.resource_seq_num = wori.resource_seq_num
1967: and woru.organization_id = wori.organization_id