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_INV_LOC_ASSIGNMENTS

Line 1237: FROM CSP_INV_LOC_ASSIGNMENTS

1233: and jtsv.task_status_id = jta.assignment_status_id;
1234:
1235: CURSOR csp_resource_org(c_resource_id number, c_resource_type varchar2) IS
1236: SELECT ORGANIZATION_ID, SUBINVENTORY_CODE
1237: FROM CSP_INV_LOC_ASSIGNMENTS
1238: WHERE RESOURCE_ID = c_resource_id
1239: AND RESOURCE_TYPE = c_resource_type
1240: AND DEFAULT_CODE = 'IN' ;
1241:

Line 2920: FROM CSP_INV_LOC_ASSIGNMENTS

2916: WHERE TASK_ASSIGNMENT_ID=c_task_assignment_id;
2917:
2918: CURSOR csp_resource_org(c_resource_id number, c_resource_type varchar2) IS
2919: SELECT ORGANIZATION_ID, SUBINVENTORY_CODE
2920: FROM CSP_INV_LOC_ASSIGNMENTS
2921: WHERE RESOURCE_ID = c_resource_id
2922: AND RESOURCE_TYPE = c_resource_type
2923: AND DEFAULT_CODE = 'IN' ;
2924:

Line 3117: FROM CSP_INV_LOC_ASSIGNMENTS

3113: ,x_msg_count OUT NOCOPY NUMBER) IS
3114:
3115: CURSOR csp_resource_org(l_resource_id number, l_resource_type varchar2) IS
3116: SELECT ORGANIZATION_ID, SUBINVENTORY_CODE
3117: FROM CSP_INV_LOC_ASSIGNMENTS
3118: WHERE RESOURCE_ID = l_resource_id
3119: AND RESOURCE_TYPE = l_resource_type
3120: AND DEFAULT_CODE = 'IN' ;
3121:

Line 7214: FROM CSP_INV_LOC_ASSIGNMENTS cil,csp_sec_inventories csi

7210: l_items csp_sch_int_pvt.alternate_items_table_type;
7211:
7212: CURSOR get_all_subinventories(l_resource_id number, l_resource_type varchar2) IS
7213: SELECT cil.ORGANIZATION_ID, cil.SUBINVENTORY_CODE
7214: FROM CSP_INV_LOC_ASSIGNMENTS cil,csp_sec_inventories csi
7215: WHERE cil.RESOURCE_ID = l_resource_id
7216: AND cil.RESOURCE_TYPE = l_resource_type
7217: AND nvl(cil.EFFECTIVE_DATE_END,sysdate) >= sysdate
7218: AND csi.organization_id = cil.organization_id

Line 7224: FROM CSP_INV_LOC_ASSIGNMENTS

7220: and csi.condition_type = 'G' ;
7221:
7222: CURSOR get_default_subinventory(l_resource_id number, l_resource_type varchar2) IS
7223: SELECT ORGANIZATION_ID, SUBINVENTORY_CODE
7224: FROM CSP_INV_LOC_ASSIGNMENTS
7225: WHERE RESOURCE_ID = l_resource_id
7226: AND RESOURCE_TYPE = l_resource_type
7227: AND DEFAULT_CODE = 'IN' ;
7228:

Line 7371: FROM CSP_INV_LOC_ASSIGNMENTS

7367: l_items csp_sch_int_pvt.alternate_items_table_type;
7368:
7369: CURSOR get_default_subinventory(l_resource_id number, l_resource_type varchar2) IS
7370: SELECT ORGANIZATION_ID, SUBINVENTORY_CODE
7371: FROM CSP_INV_LOC_ASSIGNMENTS
7372: WHERE RESOURCE_ID = l_resource_id
7373: AND RESOURCE_TYPE = l_resource_type
7374: AND DEFAULT_CODE = 'IN' ;
7375:

Line 7561: FROM CSP_INV_LOC_ASSIGNMENTS

7557: rec_pointer NUMBER;
7558:
7559: CURSOR get_default_subinventory(l_resource_id number, l_resource_type varchar2) IS
7560: SELECT ORGANIZATION_ID, SUBINVENTORY_CODE
7561: FROM CSP_INV_LOC_ASSIGNMENTS
7562: WHERE RESOURCE_ID = l_resource_id
7563: AND RESOURCE_TYPE = l_resource_type
7564: AND DEFAULT_CODE = 'IN' ;
7565:

Line 8406: FROM CSP_INV_LOC_ASSIGNMENTS

8402:
8403: CURSOR resource_org IS
8404: SELECT ORGANIZATION_ID,
8405: SUBINVENTORY_CODE
8406: FROM CSP_INV_LOC_ASSIGNMENTS
8407: WHERE RESOURCE_ID = p_new_resource_id
8408: AND RESOURCE_TYPE = p_new_resource_type
8409: AND DEFAULT_CODE = 'IN';
8410: