APPS.CSP_SCH_INT_PVT dependencies on MTL_PARAMETERS

Line 1573: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

1569: AND ORDER_LINE_ID IS NOT NULL ;*/
1570:
1571: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
1572: SELECT mri.RELATED_ITEM_ID
1573: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
1574: WHERE mp.organization_id = org_id
1575: AND mri.INVENTORY_ITEM_ID = item_id
1576: AND mri.RELATIONSHIP_TYPE_ID = 2
1577: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;

Line 2895: FROM MTL_PARAMETERS

2891: AND resource_type = c_resource_type;
2892:
2893: CURSOR get_organization_code(l_org_id number) IS
2894: SELECT ORGANIZATION_CODE
2895: FROM MTL_PARAMETERS
2896: WHERE ORGANIZATION_ID = l_org_id;
2897:
2898: cursor csp_location_ship_methods(c_from_org_id number, c_to_location_id number) IS
2899: SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),

Line 3762: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

3758: AND organization_id = org_id;
3759:
3760: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
3761: /* SELECT mri.RELATED_ITEM_ID
3762: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
3763: WHERE mp.organization_id = org_id
3764: AND mri.INVENTORY_ITEM_ID = item_id
3765: AND mri.RELATIONSHIP_TYPE_ID = 2
3766: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/

Line 3768: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp

3764: AND mri.INVENTORY_ITEM_ID = item_id
3765: AND mri.RELATIONSHIP_TYPE_ID = 2
3766: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/
3767: SELECT mri.RELATED_ITEM_ID
3768: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp
3769: WHERE mp.organization_id = org_id
3770: AND mri.INVENTORY_ITEM_ID = item_id
3771: AND mri.RELATIONSHIP_TYPE_ID = 2
3772: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;

Line 5222: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

5218: AND organization_id = org_id;
5219:
5220: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
5221: /* SELECT mri.RELATED_ITEM_ID
5222: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
5223: WHERE mp.organization_id = org_id
5224: AND mri.INVENTORY_ITEM_ID = item_id
5225: AND mri.RELATIONSHIP_TYPE_ID = 2
5226: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/

Line 5228: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp

5224: AND mri.INVENTORY_ITEM_ID = item_id
5225: AND mri.RELATIONSHIP_TYPE_ID = 2
5226: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/
5227: SELECT mri.RELATED_ITEM_ID
5228: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp
5229: WHERE mp.organization_id = org_id
5230: AND mri.INVENTORY_ITEM_ID = item_id
5231: AND mri.RELATIONSHIP_TYPE_ID = 2
5232: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;

Line 5317: FROM mtl_parameters mp

5313:
5314:
5315: CURSOR csp_resource_calendar IS
5316: SELECT mp.calendar_code,mp.calendar_exception_set_id
5317: FROM mtl_parameters mp
5318: where mp.organization_id = p_org_id;
5319:
5320:
5321: cursor get_arrival_seq_number(c_calendar_code varchar2,

Line 5394: FROM mtl_parameters mp

5390: l_msg_data varchar2(2000);
5391:
5392: CURSOR csp_resource_calendar IS
5393: SELECT mp.calendar_code,mp.calendar_exception_set_id
5394: FROM mtl_parameters mp
5395: WHERE mp.organization_id = p_to_org_id ;
5396:
5397:
5398: cursor get_arrival_seq_number(c_calendar_code varchar2,