APPS.WSH_PICK_LIST dependencies on MTL_PARAMETERS

Line 230: FROM MTL_PARAMETERS

226:
227: --Cursor to get inventory pick confirmed required flag.
228: CURSOR get_default_confirm(c_org_id IN NUMBER) IS
229: SELECT DECODE(MO_PICK_CONFIRM_REQUIRED, 2, 'Y', 'N')
230: FROM MTL_PARAMETERS
231: WHERE ORGANIZATION_ID = c_org_id;
232:
233: l_default_pickconfirm VARCHAR2(1);
234: l_init_rules VARCHAR2(1) := FND_API.G_FALSE;

Line 7009: from wsh_delivery_details d, wsh_shipping_parameters p, mtl_parameters m

7005: --Cursor to validate ship confirm.
7006: CURSOR check_detail_for_SC (c_batch_id IN NUMBER) IS
7007: select distinct p.organization_id, p.ship_confirm_rule_id,
7008: p.autocreate_deliveries_flag, m.mo_pick_confirm_required
7009: from wsh_delivery_details d, wsh_shipping_parameters p, mtl_parameters m
7010: where d.organization_id = p.organization_id and
7011: m.organization_id = d.organization_id
7012: and (ship_confirm_rule_id IS NULL
7013: or NVL(p.autocreate_deliveries_flag, 'N') <> 'Y'

Line 7029: from mtl_parameters

7025:
7026: --Cursor to check inventory pick confirm requried flag.
7027: CURSOR pick_confirm_required_for_del(c_org_id IN NUMBER) IS
7028: select mo_pick_confirm_required
7029: from mtl_parameters
7030: where organization_id = c_org_id;
7031:
7032: --OTM R12, this cursor is found if detail is not assigned to delivery
7033: --and include for planning