DBA Data[Home] [Help]

APPS.AHL_AMP_WORKBENCH_PVT dependencies on MTL_PARAMETERS

Line 86: FROM mtl_parameters param,

82:
83: CURSOR c_next_working_day(c_org_id NUMBER,c_start_date DATE )
84: IS
85: SELECT DISTINCT cal.calendar_date working_date
86: FROM mtl_parameters param,
87: bom_calendar_dates cal,
88: bom_shift_times shifts
89: WHERE param.organization_id = c_org_id
90: AND TRUNC(cal.calendar_date) >= TRUNC(c_start_date)

Line 528: MTL_PARAMETERS MP

524: ORG.ORGANIZATION_ID,
525: BOM.DESCRIPTION DEPT_DESCRIPTION
526: FROM BOM_DEPARTMENTS BOM,
527: INV_ORGANIZATION_INFO_V ORG,
528: MTL_PARAMETERS MP
529: WHERE BOM.ORGANIZATION_ID = ORG.ORGANIZATION_ID
530: AND MP.ORGANIZATION_ID = BOM.ORGANIZATION_ID
531: AND MP.EAM_ENABLED_FLAG = 'Y'
532: AND ORG.ORGANIZATION_ID = c_org_id