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 1813: update wip_op_resource_instances

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

Line 1966: wip_op_resource_instances wori

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