APPS.CSP_SCH_INT_PVT dependencies on MTL_PARAMETERS

Line 3263: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

3259: AND ORDER_LINE_ID IS NOT NULL ;*/
3260:
3261: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
3262: SELECT mri.RELATED_ITEM_ID
3263: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
3264: WHERE mp.organization_id = org_id
3265: AND mri.INVENTORY_ITEM_ID = item_id
3266: AND mri.RELATIONSHIP_TYPE_ID = 2
3267: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;

Line 4028: from mtl_parameters where organization_id = ca.organization_id;

4024: nvl(ca.subinventory_code,'-1') <> nvl(l_prev_subinventory_code,'-1') then
4025: l_transfer_cost := l_transfer_cost + ca.shipping_cost;
4026:
4027: select organization_code into l_src_org_code
4028: from mtl_parameters where organization_id = ca.organization_id;
4029:
4030: log('spares_check2','l_src_org_code:'||l_src_org_code);
4031: log('spares_check2','subinventory_code:'||ca.subinventory_code);
4032:

Line 5326: FROM MTL_PARAMETERS

5322: AND resource_type = c_resource_type;
5323:
5324: CURSOR get_organization_code(l_org_id number) IS
5325: SELECT ORGANIZATION_CODE
5326: FROM MTL_PARAMETERS
5327: WHERE ORGANIZATION_ID = l_org_id;
5328:
5329: cursor csp_location_ship_methods(c_from_org_id number, c_to_location_id number) IS
5330: select shipping_method,

Line 6202: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

6198: AND organization_id = org_id;
6199: CURSOR substitutes(item_id NUMBER,org_id NUMBER)
6200: IS
6201: /* SELECT mri.RELATED_ITEM_ID
6202: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
6203: WHERE mp.organization_id = org_id
6204: AND mri.INVENTORY_ITEM_ID = item_id
6205: AND mri.RELATIONSHIP_TYPE_ID = 2
6206: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/

Line 6209: mtl_parameters mp

6205: AND mri.RELATIONSHIP_TYPE_ID = 2
6206: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/
6207: SELECT mri.RELATED_ITEM_ID
6208: FROM MTL_RELATED_ITEMS mri,
6209: mtl_parameters mp
6210: WHERE mp.organization_id = org_id
6211: AND mri.INVENTORY_ITEM_ID = item_id
6212: AND mri.RELATIONSHIP_TYPE_ID = 2
6213: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;

Line 7764: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

7760: AND organization_id = org_id;
7761:
7762: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
7763: /* SELECT mri.RELATED_ITEM_ID
7764: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
7765: WHERE mp.organization_id = org_id
7766: AND mri.INVENTORY_ITEM_ID = item_id
7767: AND mri.RELATIONSHIP_TYPE_ID = 2
7768: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/

Line 7770: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp

7766: AND mri.INVENTORY_ITEM_ID = item_id
7767: AND mri.RELATIONSHIP_TYPE_ID = 2
7768: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/
7769: SELECT mri.RELATED_ITEM_ID
7770: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp
7771: WHERE mp.organization_id = org_id
7772: AND mri.INVENTORY_ITEM_ID = item_id
7773: AND mri.RELATIONSHIP_TYPE_ID = 2
7774: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;

Line 7859: FROM mtl_parameters mp

7855:
7856:
7857: CURSOR csp_resource_calendar IS
7858: SELECT mp.calendar_code,mp.calendar_exception_set_id
7859: FROM mtl_parameters mp
7860: where mp.organization_id = p_org_id;
7861:
7862:
7863: cursor get_arrival_seq_number(c_calendar_code varchar2,

Line 7936: FROM mtl_parameters mp

7932: l_msg_data varchar2(2000);
7933:
7934: CURSOR csp_resource_calendar IS
7935: SELECT mp.calendar_code,mp.calendar_exception_set_id
7936: FROM mtl_parameters mp
7937: WHERE mp.organization_id = p_to_org_id ;
7938:
7939:
7940: cursor get_arrival_seq_number(c_calendar_code varchar2,