DBA Data[Home] [Help]

APPS.MSC_SCH_WB dependencies on MTL_PARAMETERS

Line 765: mtl_parameters mp

761: BEGIN
762: SELECT rule_name
763: INTO atp_rule_name
764: FROM mtl_atp_rules mar,
765: mtl_parameters mp
766: WHERE
767: mar.rule_id = mp.default_atp_rule_id
768: AND mp.organization_id = org_id;
769: RETURN;

Line 1081: from mtl_parameters p, bom_cal_week_start_dates b

1077:
1078: -- The week and period is calculated based on the source org of the line.
1079: -- We may need to do it for the org in which that pegging node is
1080: cursor wk_cur is select b.week_start_date
1081: from mtl_parameters p, bom_cal_week_start_dates b
1082: where p.calendar_exception_set_id = b.exception_set_id
1083: and p.calendar_code = b.calendar_code
1084: and p.organization_id = p_organization_id
1085: and b.week_start_date > v_week_start_date

Line 1089: from mtl_parameters p, bom_period_start_dates b

1085: and b.week_start_date > v_week_start_date
1086: and b.week_start_date <= v_week_end_date;
1087:
1088: cursor pr_cur is select b.period_start_date
1089: from mtl_parameters p, bom_period_start_dates b
1090: where p.calendar_exception_set_id = b.exception_set_id
1091: and p.calendar_code = b.calendar_code
1092: and p.organization_id = p_organization_id
1093: and b.period_start_date > v_period_start_date