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.GMP_CALENDAR_PKG dependencies on MTL_PARAMETERS

Line 180: REM| - organization_id from mtl_parameters - Bug# 1252322 |

176: REM| 11/23/99 - Changed value of aggregate_resource_flag from 1 to 2 |
177: REM| 01/12/00 - Added owning_department_id column in the Insert statement |
178: REM| - Bug# 1140113 |
179: REM| 4/03/00 - using mtl_organization_id from ic_whse_mst instead of |
180: REM| - organization_id from mtl_parameters - Bug# 1252322 |
181: REM| 4/18/00 - Fixed Bug# 1273557 - Department count is Zero |
182: REM| - Changes made to the insert statement, changed |
183: REM| - s.organization_id to w.mtl_organization_id |
184: REM| 12/26/01 - Adding Code changes for Resource Utilization and Resource |

Line 219: from ic_whse_mst instead of organization_id from mtl_parameters

215:
216: Begin
217: proc_name := 'rsrc_extract';
218: /* New changes made for msc_st_department_resources- using mtl_organization_id
219: from ic_whse_mst instead of organization_id from mtl_parameters
220: table - Bug # 1252322
221: Commented the Where clause resource_whse_code is NOT NULL as whse code in
222: ic_whse_mst is never NULL - 04/03/2000
223: */

Line 320: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */

316: /* If the Resource is scheduled to Instance, then value is Yes else No */
317: || ' decode(r.schedule_ind,2,1,2), '
318: || ' 1 '/*B4487118 - HLINK GC:(RV): MULTIPLE ROWS ARE DISPALYED FOR A RESOURCE IN THE RV*/
319: /*sowsubra - ME changes - Start*/
320: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */
321: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '
322: || ' cr_rsrc_mst'||p_db_link||' m, '
323: || ' mrp_planning_exception_sets'||p_db_link||' mrp, '
324: || ' mtl_parameters'||p_db_link||' p, '

Line 324: || ' mtl_parameters'||p_db_link||' p, '

320: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */
321: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '
322: || ' cr_rsrc_mst'||p_db_link||' m, '
323: || ' mrp_planning_exception_sets'||p_db_link||' mrp, '
324: || ' mtl_parameters'||p_db_link||' p, '
325: || ' hr_organization_units'||p_db_link||' hr '
326: || ' WHERE r.organization_id = p.organization_id '
327: || ' AND r.resources = m.resources '
328: || ' AND p.organization_id = hr.organization_id '

Line 383: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */

379: || ' decode(r.schedule_ind,2,1,2), '
380: || ' 1 ' /*B4487118 - HLINK GC:(RV): MULTIPLE ROWS ARE DISPALYED FOR A RESOURCE IN THE RV*/
381: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '
382: /*sowsubra - ME changes - Start*/
383: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */
384: || ' mtl_parameters'||p_db_link||' p, '
385: || ' cr_rsrc_mst'||p_db_link||' m, '
386: || ' hr_organization_units'||p_db_link||' hr '
387: || ' where r.organization_id = p.organization_id '

Line 384: || ' mtl_parameters'||p_db_link||' p, '

380: || ' 1 ' /*B4487118 - HLINK GC:(RV): MULTIPLE ROWS ARE DISPALYED FOR A RESOURCE IN THE RV*/
381: || ' FROM cr_rsrc_dtl'||p_db_link||' r, '
382: /*sowsubra - ME changes - Start*/
383: /* Replace the use of sy_orgn_mst with mtl_parameters and hr_organization_units */
384: || ' mtl_parameters'||p_db_link||' p, '
385: || ' cr_rsrc_mst'||p_db_link||' m, '
386: || ' hr_organization_units'||p_db_link||' hr '
387: || ' where r.organization_id = p.organization_id '
388: || ' AND r.resources = m.resources '

Line 423: || ' FROM mtl_parameters'||p_db_link||' p, '

419: || ' sysdate,'
420: || ' NULL,'
421: || ' 1,'
422: || ' :instance_id '
423: || ' FROM mtl_parameters'||p_db_link||' p, '
424: || ' hr_organization_units'||p_db_link||' hr, '
425: || ' cr_rsrc_dtl'||p_db_link||' crd, '
426: || ' cr_rsrc_mst'||p_db_link||' crm '
427: || ' WHERE p.organization_id = crd.organization_id '

Line 485: || ' FROM mtl_parameters'||p_db_link||' p, '

481: || ' NULL ST_TRANSACTION_ID,'
482: || ' NULL ERROR_TEXT,'
483: || ' NULL BATCH_ID,'
484: || ' NULL COMPANY_NAME'
485: || ' FROM mtl_parameters'||p_db_link||' p, '
486: || ' hr_organization_units'||p_db_link||' hr, '
487: || ' cr_rsrc_dtl'||p_db_link||' crd, '
488: || ' cr_rsrc_mst'||p_db_link||' crm '
489: || ' WHERE p.organization_id = crd.organization_id '

Line 550: ||' mtl_parameters'||p_db_link||' m '

546: ||' FROM '
547: ||' gmp_resource_instances'||p_db_link||' gri, '
548: ||' cr_rsrc_dtl'||p_db_link||' c, '
549: ||' hr_organization_units'||p_db_link||' hr, '
550: ||' mtl_parameters'||p_db_link||' m '
551: ||' WHERE '
552: ||' gri.resource_id = c.resource_id '
553: || ' AND m.organization_id = hr.organization_id '
554: || ' AND nvl(hr.date_to,sysdate) >= sysdate '

Line 617: REM| - organization_id from mtl_parameters - Bug# 1252322 |

613: REM| 9/7/99 - Changed the Main Procedure, removed UNION ALL for main cursor|
614: REM| 9/28/99 - Changed the main query ordering by Organization Id and |
615: REM| - changed logic for populating plsqltbl |
616: REM| 4/03/00 - using mtl_organization_id from ic_whse_mst instead of |
617: REM| - organization_id from mtl_parameters - Bug# 1252322 |
618: REM| 5/03/00 - Add instance code as a prefix to the calendar code |
619: REM| - Bug # 1288143 |
620: REM| 7/07/00 - Anchor Date Problem Fixed in the Calendar Code |
621: REM| - Bug # 1337084. |

Line 738: /* mtl_parameters.organization_id - Bug# 1252322 */

734: NULL ;
735: ELSE
736: RAISE invalid_string_value ;
737: END IF;
738: /* mtl_parameters.organization_id - Bug# 1252322 */
739:
740: /* Select All the calendars which have calendar_code associated with
741: resources and if not associated then organization calendar_code */
742: stmt_no := 15;

Line 751: || ' mtl_parameters'||p_db_link||' mp, '

747: || ' mp.organization_id organization_id, '
748: || ' 0 '
749: || ' FROM bom_calendars'||p_db_link||' cal, '
750: || ' hr_organization_units'||p_db_link||' hr, '
751: || ' mtl_parameters'||p_db_link||' mp, '
752: || ' cr_rsrc_dtl'||p_db_link||' crd '
753: || ' WHERE mp.organization_id = hr.organization_id '
754: || ' AND nvl(hr.date_to,sysdate) >= sysdate '
755: || ' AND mp.process_enabled_flag = '||''''||'Y'||''''

Line 849: ||' FROM mtl_parameters'||p_db_link

845: stmt_no := 29 ;
846: Upd_Process_Org := 'UPDATE MSC_ST_TRADING_PARTNERS'
847: ||' SET organization_type = 2'
848: ||' WHERE sr_tp_id in (SELECT organization_id '
849: ||' FROM mtl_parameters'||p_db_link
850: ||' WHERE process_enabled_flag = '||''''||'Y'||'''' || ')'
851: ||' AND partner_type = 3' ;
852:
853: EXECUTE IMMEDIATE Upd_Process_Org;

Line 896: || ' mtl_parameters'||p_db_link||' m, '

892: || ' gra.resource_units, '
893: || ' 2 '
894: || ' FROM '
895: || ' gmp_resource_avail'||p_db_link||' gra, '
896: || ' mtl_parameters'||p_db_link||' m, '
897: || ' cr_rsrc_dtl'||p_db_link||' crd '
898: || ' WHERE nvl(gra.resource_instance_id,0) = 0 '
899: || ' AND nvl(crd.calendar_code,m.calendar_code) = gra.calendar_code '
900: || ' AND gra.organization_id = crd.organization_id '

Line 945: || ' mtl_parameters'||p_db_link||' m, '

941: || ' :instance_id '
942: || ' FROM '
943: || ' gmp_resource_instances'||p_db_link||' gri, '
944: || ' gmp_resource_avail'||p_db_link||' gra, '
945: || ' mtl_parameters'||p_db_link||' m, '
946: || ' cr_rsrc_dtl'||p_db_link||' crd '
947: || ' WHERE gri.resource_id = gra.resource_id '
948: || ' AND gri.instance_id = gra.resource_instance_id '
949: || ' AND gri.inactive_ind = 0 '

Line 987: || ' mtl_parameters'||p_db_link||' m, '

983: || ' 2, '
984: || ' :instance_id, '
985: || ' crd.assigned_qty '
986: || ' FROM gmp_calendar_detail_gtmp'||p_db_link||' gtmp, '
987: || ' mtl_parameters'||p_db_link||' m, '
988: || ' cr_rsrc_dtl'||p_db_link||' crd '
989: || ' WHERE NVL(crd.calendar_code,m.calendar_code) = gtmp.calendar_code '
990: || ' AND m.organization_id = crd.organization_id '
991: || ' AND m.process_enabled_flag = '||''''||'Y'||''''

Line 1613: || ' FROM mtl_parameters'||p_db_link

1609: stmt_no := 72;
1610: -- Rajesh Patangya B4724360, When the calendar is not assigned to
1611: -- resource then organization calendar should be considered
1612: sqlstmt := ' SELECT calendar_code '
1613: || ' FROM mtl_parameters'||p_db_link
1614: || ' WHERE organization_id = :orgn_id1 ';
1615:
1616: EXECUTE IMMEDIATE sqlstmt INTO g_calendar_code USING p_org_id ;
1617:

Line 2255: FROM cr_rsrc_dtl c , mtl_parameters m

2251: SELECT MIN(RESOURCES), MAX(RESOURCES) into VRESOURCE_FROM, VRESOURCE_TO
2252: FROM (
2253: SELECT crd.RESOURCES FROM
2254: ( SELECT RESOURCES , RESOURCE_id , c.LAST_UPDATE_DATE
2255: FROM cr_rsrc_dtl c , mtl_parameters m
2256: WHERE c.ORGANIZATION_ID = p_org_id
2257: AND c.ORGANIZATION_ID = m.organization_id
2258: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2259: UNION

Line 2261: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_unavail_man b

2257: AND c.ORGANIZATION_ID = m.organization_id
2258: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2259: UNION
2260: SELECT c.RESOURCES , c.RESOURCE_id , b.LAST_UPDATE_DATE
2261: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_unavail_man b
2262: WHERE c.ORGANIZATION_ID = p_org_id
2263: AND c.ORGANIZATION_ID = m.organization_id
2264: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2265: AND c.resource_id = b.resource_id

Line 2269: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_excp_asnmt b

2265: AND c.resource_id = b.resource_id
2266: UNION
2267: -- VKINDURI BUG 13645301 Resource Unavailability
2268: SELECT c.RESOURCES , c.RESOURCE_id , MAX(b.LAST_UPDATE_DATE) LAST_UPDATE_DATE
2269: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_excp_asnmt b
2270: WHERE c.ORGANIZATION_ID = p_org_id
2271: AND c.ORGANIZATION_ID = m.organization_id
2272: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2273: AND c.resource_id = b.resource_id

Line 2284: FROM cr_rsrc_dtl c , mtl_parameters m

2280: ) gmp
2281: WHERE crd.LAST_UPDATE_DATE > gmp.lud AND crd.resource_id = gmp.resource_id
2282: UNION
2283: SELECT c.RESOURCES
2284: FROM cr_rsrc_dtl c , mtl_parameters m
2285: WHERE c.ORGANIZATION_ID = p_org_id
2286: AND c.ORGANIZATION_ID = m.organization_id
2287: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2288: AND NOT EXISTS ( SELECT 1 FROM gmp_resource_avail gmp

Line 2314: ||' mtl_parameters m '

2310: log_message('Called_from = V_APS and res_count>1 OR bom_result>0 OR Called_from = V_WPS IF condition');
2311: stmt_no := 1 ;
2312: sql_get_orgn := ' SELECT m.organization_code '
2313: ||' FROM hr_organization_units hr, '
2314: ||' mtl_parameters m '
2315: ||' WHERE m.organization_id = :orgn_id '
2316: ||' AND m.organization_id = hr.organization_id '
2317: ||' AND nvl(hr.date_to,sysdate) >= sysdate '
2318: ||' AND m.process_enabled_flag = '||''''||'Y'||'''';

Line 2339: ||' mtl_parameters m, '

2335: sql_get_cal := ' SELECT DISTINCT cal.calendar_code, '
2336: ||' cal.description '
2337: ||' FROM bom_calendars cal, '
2338: ||' hr_organization_units hr, '
2339: ||' mtl_parameters m, '
2340: ||' cr_rsrc_dtl crd '
2341: ||' WHERE m.organization_id = :orgn_id '
2342: ||' AND m.organization_id = hr.organization_id '
2343: ||' AND nvl(hr.date_to,sysdate) >= sysdate '

Line 2603: || ' FROM mtl_parameters'||p_db_link

2599:
2600: -- Rajesh Patangya B4724360, When the calendar is not assigned to
2601: -- resource then organization calendar should be considered
2602: sqlstmt := ' SELECT calendar_code '
2603: || ' FROM mtl_parameters'||p_db_link
2604: || ' WHERE organization_id = :orgn_id1 ';
2605:
2606: log_message ('in net_rsrc_avail_calculate proc');
2607: EXECUTE IMMEDIATE sqlstmt INTO g_calendar_code USING p_org_id ;