eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPOPRN dependencies on WIP_SUB_OPERATION_RESOURCES

Line 977: FROM WIP_SUB_OPERATION_RESOURCES WSOR

973:
974: BEGIN
975: SELECT nvl(max(resource_seq_num), 10)
976: INTO l_wsor_max_res_seq_num
977: FROM WIP_SUB_OPERATION_RESOURCES WSOR
978: WHERE wip_entity_id = x_wip_entity_id
979: AND OPERATION_SEQ_NUM = x_to_op;
980: EXCEPTION
981: WHEN no_data_found THEN

Line 986: INSERT INTO WIP_SUB_OPERATION_RESOURCES

982: null;
983: END;
984:
985: IF (l_count=0) THEN --jump outside rtg
986: INSERT INTO WIP_SUB_OPERATION_RESOURCES
987: (wip_entity_id,
988: operation_seq_num,
989: resource_seq_num,
990: organization_id,

Line 1035: FROM WIP_SUB_OPERATION_RESOURCES WSOR

1031: SELECT WO.wip_entity_id,
1032: x_to_op,
1033: --bug 3311695 changed the select below to a private function to be compatible with db 8.1.7.4
1034: /* rownum + (SELECT nvl(max(resource_seq_num), 10)
1035: FROM WIP_SUB_OPERATION_RESOURCES WSOR
1036: WHERE wip_entity_id = x_wip_entity_id
1037: AND OPERATION_SEQ_NUM = x_to_op),--.resource_seq_num
1038: */
1039: (rownum + l_wsor_max_res_seq_num),

Line 3271: INSERT INTO WIP_SUB_OPERATION_RESOURCES

3267: end if;
3268:
3269: l_stmt_num := 80;
3270: --MES added department_id
3271: INSERT INTO WIP_SUB_OPERATION_RESOURCES
3272: (wip_entity_id,
3273: operation_seq_num,
3274: resource_seq_num,
3275: organization_id,

Line 3372: ' records in WIP_SUB_OPERATION_RESOURCES.');

3368: AND WCOR.recommended<>'Y';
3369:
3370: if (l_debug = 'Y') then
3371: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||SQL%ROWCOUNT||
3372: ' records in WIP_SUB_OPERATION_RESOURCES.');
3373: end if;
3374:
3375: l_stmt_num := 90;
3376: