DBA Data[Home] [Help]

APPS.WSMPJUPD dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1914: INSERT INTO WIP_OP_RESOURCE_INSTANCES

1910: l_stmt_num := 30;
1911:
1912: forall l_job_counter in indices of p_new_rj_we_id_tbl
1913:
1914: INSERT INTO WIP_OP_RESOURCE_INSTANCES
1915: ( WIP_ENTITY_ID ,
1916: OPERATION_SEQ_NUM,
1917: RESOURCE_SEQ_NUM ,
1918: ORGANIZATION_ID ,

Line 1947: wip_op_resource_instances wori

1943: wori.START_DATE ,
1944: wori.COMPLETION_DATE,
1945: wori.BATCH_ID
1946: FROM
1947: wip_op_resource_instances wori
1948: WHERE
1949: wori.wip_entity_id = p_rep_we_id
1950: AND wori.operation_seq_num <= p_curr_op_seq_num
1951: );