[Home] [Help]
29: , item_id mtl_system_items.inventory_item_id%TYPE
30: , lot_ctl mtl_system_items.lot_control_code%TYPE
31: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE
32: , primary_uom mtl_system_items.primary_uom_code%TYPE
33: , accru_acct mtl_parameters.ap_accrual_account%TYPE
34: , ipv_acct mtl_parameters.invoice_price_var_account%TYPE
35: , budget_acct mtl_system_items.encumbrance_account%TYPE
36: , charge_acct mtl_system_items.expense_account%TYPE
37: , src_type mtl_system_items.source_type%TYPE
30: , lot_ctl mtl_system_items.lot_control_code%TYPE
31: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE
32: , primary_uom mtl_system_items.primary_uom_code%TYPE
33: , accru_acct mtl_parameters.ap_accrual_account%TYPE
34: , ipv_acct mtl_parameters.invoice_price_var_account%TYPE
35: , budget_acct mtl_system_items.encumbrance_account%TYPE
36: , charge_acct mtl_system_items.expense_account%TYPE
37: , src_type mtl_system_items.source_type%TYPE
38: , src_org mtl_system_items.source_organization_id%TYPE
43: , unit_price mtl_system_items.list_price_per_unit%TYPE
44: , mbf mtl_system_items.planning_make_buy_code%TYPE
45: , build_in_wip mtl_system_items.build_in_wip_flag%TYPE
46: /* nsinghi MIN-MAX INVCONV start */
47: , process_enabled mtl_parameters.process_enabled_flag%TYPE
48: , recipe_enabled mtl_system_items.recipe_enabled_flag%TYPE
49: , execution_enabled mtl_system_items.process_execution_enabled_flag%TYPE
50: /* nsinghi MIN-MAX INVCONV end */
51: , pick_components mtl_system_items.pick_components_flag%TYPE
322: pick_components_flag pick_components
323: FROM mtl_categories b,
324: mtl_item_categories a,
325: mtl_system_items_vl c,
326: mtl_parameters p
327: WHERE b.category_id = a.category_id
328: AND b.structure_id = :mcat_struct_id
329: AND c.inventory_item_flag = ''Y''
330: AND p.organization_id = :org_id
404: pick_components_flag
405: FROM mtl_categories b,
406: mtl_item_categories a,
407: mtl_system_items_vl c,
408: mtl_parameters p,
409: mtl_secondary_inventories m,
410: mtl_item_sub_inventories s
411: WHERE b.category_id = a.category_id
412: AND b.structure_id = :mcat_struct_id
470: pick_components_flag
471: FROM mtl_categories b,
472: mtl_item_categories a,
473: mtl_system_items_vl c,
474: mtl_parameters p,
475: per_all_people_f v
476: WHERE b.category_id = a.category_id
477: AND b.structure_id = :mcat_struct_id
478: AND c.inventory_item_flag = ''Y''
561: pick_components_flag
562: FROM mtl_categories b,
563: mtl_item_categories a,
564: mtl_system_items_vl c,
565: mtl_parameters p,
566: mtl_secondary_inventories m,
567: mtl_item_sub_inventories s,
568: per_all_people_f v
569: WHERE b.category_id = a.category_id
2866:
2867: BEGIN
2868: SELECT p.calendar_code, p.calendar_exception_set_id
2869: INTO l_so_cal_code, l_so_exception_set_id
2870: FROM mtl_parameters p
2871: WHERE p.organization_id = l_src_org;
2872:
2873: SELECT c1.calendar_date
2874: INTO x_scheduled_ship_date
3069: ) IS
3070:
3071: l_recipe_enabled mtl_system_items.recipe_enabled_flag%TYPE;
3072: l_execution_enabled mtl_system_items.process_execution_enabled_flag%TYPE;
3073: l_process_enabled mtl_parameters.process_enabled_flag%TYPE;
3074:
3075: BEGIN
3076:
3077: l_recipe_enabled := 'N';
3078: l_execution_enabled := 'N';
3079: l_process_enabled := 'N';
3080:
3081: SELECT NVL(process_enabled_flag,'N') INTO l_process_enabled
3082: FROM mtl_parameters
3083: WHERE organization_id = p_organization_id;
3084:
3085: IF l_process_enabled = 'Y' THEN
3086: SELECT NVL(recipe_enabled_flag, 'N'), NVL(process_execution_enabled_flag, 'N')