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.CSP_SCH_INT_PVT dependencies on CSP_PICK_UTILS

Line 354: and csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'PARTIALLY RECEIVED';

350: AND h.requirement_header_id = l.requirement_header_id
351: AND l.requirement_line_id = d.requirement_line_id
352: and d.source_type = 'IO'
353: AND d.source_id = oola.line_id
354: and csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'PARTIALLY RECEIVED';
355:
356: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
358: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 391: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'

387: AND h.requirement_header_id = l.requirement_header_id
388: AND l.requirement_line_id = dio.requirement_line_id
389: AND dio.source_type = 'IO'
390: and dio.source_id = oola.line_id
391: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
392: AND dio.requirement_line_id = dres.requirement_line_id
393: AND oola.inventory_item_id = mr.inventory_item_id
394: AND oola.ordered_quantity = mr.reservation_quantity
395: AND dres.source_type = 'RES'

Line 449: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'

445: AND h.requirement_header_id = l.requirement_header_id
446: AND l.requirement_line_id = dio.requirement_line_id
447: AND dio.source_type = 'IO'
448: and dio.source_id = oola.line_id
449: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
450: AND dio.requirement_line_id = dres.requirement_line_id
451: AND oola.inventory_item_id = mr.inventory_item_id
452: AND oola.ordered_quantity = mr.reservation_quantity
453: AND dres.source_type = 'RES'

Line 482: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'

478: AND h.requirement_header_id = l.requirement_header_id
479: AND l.requirement_line_id = dio.requirement_line_id
480: AND dio.source_type = 'IO'
481: AND dio.source_id = oola.line_id
482: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
483: AND dio.requirement_line_id = dres.requirement_line_id
484: AND oola.inventory_item_id = mr.inventory_item_id
485: AND oola.ordered_quantity = mr.reservation_quantity
486: AND dres.source_type = 'RES'

Line 537: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'

533: AND h.requirement_header_id = l.requirement_header_id
534: AND l.requirement_line_id = dio.requirement_line_id
535: AND dio.source_type = 'IO'
536: AND dio.source_id = oola.line_id
537: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
538: AND dio.requirement_line_id = dres.requirement_line_id
539: AND oola.inventory_item_id = mr.inventory_item_id
540: AND oola.ordered_quantity = mr.reservation_quantity
541: AND dres.source_type = 'RES'

Line 591: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'

587: AND h.requirement_header_id = l.requirement_header_id
588: AND l.requirement_line_id = dio.requirement_line_id
589: AND dio.source_type = 'IO'
590: AND dio.source_id = oola.line_id
591: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
592: AND dio.requirement_line_id = dres.requirement_line_id
593: AND oola.inventory_item_id = mr.inventory_item_id
594: AND oola.ordered_quantity = mr.reservation_quantity
595: AND dres.source_type = 'RES'

Line 640: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');

636: AND h.requirement_header_id = l.requirement_header_id
637: AND l.requirement_line_id = d.requirement_line_id
638: AND d.source_type = 'IO'
639: AND d.source_id = oola.line_id
640: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
641:
642: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
643: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
644: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 678: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) IN ('SHIPPED', 'EXPECTED')

674: AND l.requirement_line_id = d.requirement_line_id
675: AND d.source_type = 'IO'
676: AND d.source_id = oola.line_id
677: AND oola.header_id = ooha.header_id
678: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) IN ('SHIPPED', 'EXPECTED')
679: AND rownum = 1;
680:
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');

Line 706: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')

702: AND l.requirement_line_id = d.requirement_line_id
703: AND h.address_type IN ('T', 'C', 'P')
704: AND d.source_type = 'IO'
705: AND d.source_id = oola.line_id
706: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
707: AND dother.requirement_line_id = l.requirement_line_id
708: AND dother.source_id <> d.source_id;
709:
710: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 751: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')

747: AND h.requirement_header_id = l.requirement_header_id
748: AND l.requirement_line_id = d.requirement_line_id
749: AND d.source_type = 'IO'
750: AND d.source_id = oola.line_id
751: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
752: );
753:
754: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
755: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 796: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')

792: AND h.requirement_header_id = l.requirement_header_id
793: AND l.requirement_line_id = d.requirement_line_id
794: AND d.source_type = 'IO'
795: AND d.source_id = oola.line_id
796: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
797: );
798:
799: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
800: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 818: AND csp_pick_utils.get_order_status(oel.line_id,oel.flow_status_code) in ('SHIPPED', 'EXPECTED')

814: AND h.task_assignment_id = r_asgn.task_assignment_id
815: AND h.requirement_header_id = l.requirement_header_id
816: AND l.requirement_line_id = d.requirement_line_id
817: AND d.source_type = 'IO'
818: AND csp_pick_utils.get_order_status(oel.line_id,oel.flow_status_code) in ('SHIPPED', 'EXPECTED')
819: AND d.source_id = oel.line_id;
820:
821: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
822: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 904: --AND csp_pick_utils.get_order_status(oel.line_id,oel.flow_status_code) in ('SHIPPED', 'EXPECTED')

900: AND h.task_assignment_id = r_asgn.task_assignment_id
901: AND h.requirement_header_id = l.requirement_header_id
902: AND l.requirement_line_id = d.requirement_line_id
903: AND d.source_type = 'IO'
904: --AND csp_pick_utils.get_order_status(oel.line_id,oel.flow_status_code) in ('SHIPPED', 'EXPECTED')
905: AND d.source_id = oel.line_id;
906:
907: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
908: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1367: l_resource_name := csp_pick_utils.get_object_name(p_options.resource_type, p_options.resource_id);

1363: SELECT NAME
1364: INTO l_resource_type_name
1365: FROM JTF_OBJECTS_VL
1366: WHERE OBJECT_CODE = p_options.resource_type;
1367: l_resource_name := csp_pick_utils.get_object_name(p_options.resource_type, p_options.resource_id);
1368: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1369: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name, FALSE);
1370: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
1371: FND_MSG_PUB.ADD;

Line 1405: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'

1401: AND h.requirement_header_id = l.requirement_header_id
1402: AND l.requirement_line_id = dio.requirement_line_id
1403: AND dio.source_type = 'IO'
1404: AND dio.source_id = oola.line_id
1405: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
1406: AND dio.requirement_line_id = dres.requirement_line_id
1407: AND oola.inventory_item_id = mr.inventory_item_id
1408: AND oola.ordered_quantity = mr.reservation_quantity
1409: AND dres.source_type = 'RES'

Line 1456: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');

1452: and h.address_type in ('C', 'T', 'P')
1453: AND l.requirement_line_id = d.requirement_line_id
1454: AND d.source_type = 'IO'
1455: AND d.source_id = oola.line_id
1456: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
1457:
1458: log('choose_option', 'l_shpd_lines=' || l_shpd_lines);
1459:
1460: if l_shpd_lines > 0 then

Line 2510: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'

2506: AND h.requirement_header_id = l.requirement_header_id
2507: AND l.requirement_line_id = dio.requirement_line_id
2508: AND dio.source_type = 'IO'
2509: AND dio.source_id = oola.line_id
2510: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
2511: AND dio.requirement_line_id = dres.requirement_line_id
2512: AND oola.inventory_item_id = mr.inventory_item_id
2513: AND oola.ordered_quantity = mr.reservation_quantity
2514: AND dres.source_type = 'RES'

Line 2540: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');

2536: and h.address_type in ('C', 'T', 'P')
2537: AND l.requirement_line_id = d.requirement_line_id
2538: AND d.source_type = 'IO'
2539: AND d.source_id = oola.line_id
2540: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
2541:
2542: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2543: fnd_log.string(fnd_log.level_statement, l_module_name,
2544: 'l_shpd_lines=' || l_shpd_lines);

Line 3145: /*select csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id)

3141: EXIT WHEN csp_resource_org%NOTFOUND ;
3142: END LOOP;
3143:
3144: IF csp_resource_org%rowcount =0 THEN
3145: /*select csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id)
3146: INTO l_resource_name
3147: FROM DUAL;*/
3148: OPEN csp_resource_type_name(p_resources(I).resource_type);
3149: LOOP

Line 3154: l_resource_name := csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id);

3150: FETCH csp_resource_type_name INTO l_resource_type_name;
3151: EXIT WHEN csp_resource_type_name%NOTFOUND;
3152: END LOOP;
3153: CLOSE csp_resource_type_name;
3154: l_resource_name := csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id);
3155: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
3156: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
3157: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3158: FND_MSG_PUB.ADD;

Line 8379: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'

8375: AND h.requirement_header_id = l.requirement_header_id
8376: AND l.requirement_line_id = dio.requirement_line_id
8377: AND dio.source_type = 'IO'
8378: AND dio.source_id = oola.line_id
8379: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
8380: AND dio.requirement_line_id = dres.requirement_line_id
8381: AND oola.inventory_item_id = mr.inventory_item_id
8382: AND oola.ordered_quantity = mr.reservation_quantity
8383: AND dres.source_type = 'RES'

Line 8431: l_resource_name := csp_pick_utils.get_object_name(p_new_resource_type, p_new_resource_id);

8427: log('move_parts_on_reassign', 'l_new_dest_subinv=' || l_new_dest_subinv);
8428:
8429: if l_new_dest_org = -999 then
8430: x_return_status := FND_API.G_RET_STS_ERROR;
8431: l_resource_name := csp_pick_utils.get_object_name(p_new_resource_type, p_new_resource_id);
8432: SELECT NAME
8433: into l_resource_type_name
8434: FROM JTF_OBJECTS_VL
8435: WHERE OBJECT_CODE = p_new_resource_type;