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 7151: from wsh_delivery_details d, wsh_shipping_parameters p, mtl_parameters m

7147: --Cursor to validate ship confirm.
7148: CURSOR check_detail_for_SC (c_batch_id IN NUMBER) IS
7149: select distinct p.organization_id, p.ship_confirm_rule_id,
7150: p.autocreate_deliveries_flag, m.mo_pick_confirm_required
7151: from wsh_delivery_details d, wsh_shipping_parameters p, mtl_parameters m
7152: where d.organization_id = p.organization_id and
7153: m.organization_id = d.organization_id
7154: and (ship_confirm_rule_id IS NULL
7155: or NVL(p.autocreate_deliveries_flag, 'N') <> 'Y'

Line 7171: from mtl_parameters

7167:
7168: --Cursor to check inventory pick confirm requried flag.
7169: CURSOR pick_confirm_required_for_del(c_org_id IN NUMBER) IS
7170: select mo_pick_confirm_required
7171: from mtl_parameters
7172: where organization_id = c_org_id;
7173:
7174: --OTM R12, this cursor is found if detail is not assigned to delivery
7175: --and include for planning