APPS.INVWATP dependencies on MTL_PARAMETERS

Line 76: -- msi table does has null atp rule id, so take it from mtl parameters

72: where
73: inventory_item_id = x_inventory_item_id and
74: organization_id = x_organization_id;
75:
76: -- msi table does has null atp rule id, so take it from mtl parameters
77: -- from org definition.
78: if rec_mgav.atp_rule_id is null then
79: begin
80: SELECT r.rule_id

Line 84: mtl_parameters p, mtl_atp_rules r

80: SELECT r.rule_id
81: INTO
82: rec_mgav.atp_rule_id
83: FROM
84: mtl_parameters p, mtl_atp_rules r
85: WHERE
86: p.default_atp_rule_id = r.rule_id
87: AND p.organization_id = x_organization_id;
88: exception

Line 155: FROM HR_ORGANIZATION_UNITS HR, MTL_PARAMETERS MTL

151: begin
152: -- calendar organization id
153: SELECT MTL.ORGANIZATION_ID
154: into rec_mgav.atp_calendar_organization_id
155: FROM HR_ORGANIZATION_UNITS HR, MTL_PARAMETERS MTL
156: WHERE HR.ORGANIZATION_ID = MTL.ORGANIZATION_ID
157: AND MTL.CALENDAR_CODE is not null
158: AND MTL.CALENDAR_EXCEPTION_SET_ID is not null
159: AND MTL.ORGANIZATION_ID = x_organization_id;