eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MINMAX_PVT dependencies on MTL_SYSTEM_ITEMS

Line 15: , description mtl_system_items.description%TYPE

11:
12:
13: TYPE minmax_items_rectype IS RECORD
14: ( item VARCHAR2(1000)
15: , description mtl_system_items.description%TYPE
16: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
17: , min_qty mtl_system_items.min_minmax_quantity%TYPE
18: , max_qty mtl_system_items.max_minmax_quantity%TYPE
19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE

Line 16: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE

12:
13: TYPE minmax_items_rectype IS RECORD
14: ( item VARCHAR2(1000)
15: , description mtl_system_items.description%TYPE
16: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
17: , min_qty mtl_system_items.min_minmax_quantity%TYPE
18: , max_qty mtl_system_items.max_minmax_quantity%TYPE
19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE

Line 17: , min_qty mtl_system_items.min_minmax_quantity%TYPE

13: TYPE minmax_items_rectype IS RECORD
14: ( item VARCHAR2(1000)
15: , description mtl_system_items.description%TYPE
16: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
17: , min_qty mtl_system_items.min_minmax_quantity%TYPE
18: , max_qty mtl_system_items.max_minmax_quantity%TYPE
19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE

Line 18: , max_qty mtl_system_items.max_minmax_quantity%TYPE

14: ( item VARCHAR2(1000)
15: , description mtl_system_items.description%TYPE
16: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
17: , min_qty mtl_system_items.min_minmax_quantity%TYPE
18: , max_qty mtl_system_items.max_minmax_quantity%TYPE
19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE

Line 19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE

15: , description mtl_system_items.description%TYPE
16: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
17: , min_qty mtl_system_items.min_minmax_quantity%TYPE
18: , max_qty mtl_system_items.max_minmax_quantity%TYPE
19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
23: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE

Line 20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE

16: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
17: , min_qty mtl_system_items.min_minmax_quantity%TYPE
18: , max_qty mtl_system_items.max_minmax_quantity%TYPE
19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
23: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
24: , buying_lead_time mtl_system_items.full_lead_time%TYPE

Line 21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE

17: , min_qty mtl_system_items.min_minmax_quantity%TYPE
18: , max_qty mtl_system_items.max_minmax_quantity%TYPE
19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
23: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
24: , buying_lead_time mtl_system_items.full_lead_time%TYPE
25: , planner mtl_system_items.planner_code%TYPE

Line 22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE

18: , max_qty mtl_system_items.max_minmax_quantity%TYPE
19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
23: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
24: , buying_lead_time mtl_system_items.full_lead_time%TYPE
25: , planner mtl_system_items.planner_code%TYPE
26: , buyer per_all_people_f.full_name%TYPE

Line 23: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE

19: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
23: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
24: , buying_lead_time mtl_system_items.full_lead_time%TYPE
25: , planner mtl_system_items.planner_code%TYPE
26: , buyer per_all_people_f.full_name%TYPE
27: , category VARCHAR2(800)

Line 24: , buying_lead_time mtl_system_items.full_lead_time%TYPE

20: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
23: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
24: , buying_lead_time mtl_system_items.full_lead_time%TYPE
25: , planner mtl_system_items.planner_code%TYPE
26: , buyer per_all_people_f.full_name%TYPE
27: , category VARCHAR2(800)
28: , category_id mtl_categories.category_id%TYPE

Line 25: , planner mtl_system_items.planner_code%TYPE

21: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
22: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
23: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
24: , buying_lead_time mtl_system_items.full_lead_time%TYPE
25: , planner mtl_system_items.planner_code%TYPE
26: , buyer per_all_people_f.full_name%TYPE
27: , category VARCHAR2(800)
28: , category_id mtl_categories.category_id%TYPE
29: , item_id mtl_system_items.inventory_item_id%TYPE

Line 29: , item_id mtl_system_items.inventory_item_id%TYPE

25: , planner mtl_system_items.planner_code%TYPE
26: , buyer per_all_people_f.full_name%TYPE
27: , category VARCHAR2(800)
28: , category_id mtl_categories.category_id%TYPE
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

Line 30: , lot_ctl mtl_system_items.lot_control_code%TYPE

26: , buyer per_all_people_f.full_name%TYPE
27: , category VARCHAR2(800)
28: , category_id mtl_categories.category_id%TYPE
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

Line 31: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE

27: , category VARCHAR2(800)
28: , category_id mtl_categories.category_id%TYPE
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

Line 32: , primary_uom mtl_system_items.primary_uom_code%TYPE

28: , category_id mtl_categories.category_id%TYPE
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

Line 35: , budget_acct mtl_system_items.encumbrance_account%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
39: , src_subinv mtl_system_items.source_subinventory%TYPE

Line 36: , charge_acct mtl_system_items.expense_account%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
39: , src_subinv mtl_system_items.source_subinventory%TYPE
40: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE

Line 37: , src_type mtl_system_items.source_type%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
39: , src_subinv mtl_system_items.source_subinventory%TYPE
40: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE

Line 38: , src_org mtl_system_items.source_organization_id%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
39: , src_subinv mtl_system_items.source_subinventory%TYPE
40: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
42: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE

Line 39: , src_subinv mtl_system_items.source_subinventory%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
39: , src_subinv mtl_system_items.source_subinventory%TYPE
40: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
42: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
43: , unit_price mtl_system_items.list_price_per_unit%TYPE

Line 40: , purch_flag mtl_system_items.purchasing_enabled_flag%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
39: , src_subinv mtl_system_items.source_subinventory%TYPE
40: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
42: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
43: , unit_price mtl_system_items.list_price_per_unit%TYPE
44: , mbf mtl_system_items.planning_make_buy_code%TYPE

Line 41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE

37: , src_type mtl_system_items.source_type%TYPE
38: , src_org mtl_system_items.source_organization_id%TYPE
39: , src_subinv mtl_system_items.source_subinventory%TYPE
40: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
42: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%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

Line 42: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE

38: , src_org mtl_system_items.source_organization_id%TYPE
39: , src_subinv mtl_system_items.source_subinventory%TYPE
40: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
42: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%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 */

Line 43: , unit_price mtl_system_items.list_price_per_unit%TYPE

39: , src_subinv mtl_system_items.source_subinventory%TYPE
40: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
42: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%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

Line 44: , mbf mtl_system_items.planning_make_buy_code%TYPE

40: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
42: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%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

Line 45: , build_in_wip mtl_system_items.build_in_wip_flag%TYPE

41: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
42: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%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

Line 48: , recipe_enabled mtl_system_items.recipe_enabled_flag%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
52: );

Line 49: , execution_enabled mtl_system_items.process_execution_enabled_flag%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
52: );
53:

Line 51: , pick_components mtl_system_items.pick_components_flag%TYPE

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
52: );
53:
54: --
55: -- Start of forward declarations

Line 325: mtl_system_items_vl c,

321: /* nsinghi MIN-MAX INVCONV end */
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''

Line 407: mtl_system_items_vl c,

403: /* nsinghi MIN-MAX INVCONV end */
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

Line 473: mtl_system_items_vl c,

469: /* nsinghi MIN-MAX INVCONV end */
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

Line 564: mtl_system_items_vl c,

560: /* nsinghi MIN-MAX INVCONV end */
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

Line 1325: FROM mtl_system_items_vl msiv , mtl_units_of_measure_vl muom

1321: primary uom code */
1322:
1323: SELECT uom_code
1324: INTO l_puom
1325: FROM mtl_system_items_vl msiv , mtl_units_of_measure_vl muom
1326: WHERE msiv.inventory_item_id = p_item_id
1327: AND msiv.organization_id = p_org_id
1328: AND muom.unit_of_measure = msiv.primary_unit_of_measure;
1329:

Line 3071: l_recipe_enabled mtl_system_items.recipe_enabled_flag%TYPE;

3067: , x_ret_mesg OUT NOCOPY VARCHAR2
3068: , p_osfm_batch_id IN NUMBER DEFAULT NULL /* Added for Bug 6807835 */
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

Line 3072: l_execution_enabled mtl_system_items.process_execution_enabled_flag%TYPE;

3068: , p_osfm_batch_id IN NUMBER DEFAULT NULL /* Added for Bug 6807835 */
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:

Line 3088: FROM mtl_system_items

3084:
3085: IF l_process_enabled = 'Y' THEN
3086: SELECT NVL(recipe_enabled_flag, 'N'), NVL(process_execution_enabled_flag, 'N')
3087: INTO l_recipe_enabled, l_execution_enabled
3088: FROM mtl_system_items
3089: WHERE organization_id = p_organization_id
3090: AND inventory_item_id = p_item_id;
3091: END IF;
3092:

Line 3532: FROM mtl_system_items

3528: SELECT dual_uom_control,
3529: secondary_uom_code
3530: INTO l_dual_uom_control,
3531: l_secondary_uom
3532: FROM mtl_system_items
3533: WHERE organization_id = p_organization_id
3534: AND inventory_item_id = p_item_id;
3535:
3536: IF l_dual_uom_control > 1 THEN

Line 3720: and discrete as the leadtime would require to be calculated for the mtl_system_items in

3716: x_est_date => l_need_by_date);
3717: /* nsinghi MIN-MAX INVCONV start */
3718: /* For process org, call needs to be made against to the GME batch API.
3719: We need to retain the above estimate_leadtime call for both Process
3720: and discrete as the leadtime would require to be calculated for the mtl_system_items in
3721: the converged model. The leadtime calculated by wip_calendar.estimate_leadtime is
3722: fixed_lead_time + (variable_lead_time * qty) which is common to process too. */
3723:
3724:

Line 3943: FROM mtl_system_items msi

3939: IF p_pur_revision = 1
3940: THEN
3941: SELECT revision_qty_control_code
3942: INTO l_item_rev_ctl
3943: FROM mtl_system_items msi
3944: WHERE msi.organization_id = l_orgn_id
3945: AND msi.inventory_item_id = p_item_id;
3946:
3947: IF G_TRACE_ON = 1 THEN

Line 3984: from mtl_system_items_vl msiv , mtl_units_of_measure_vl muom

3980: l_check_uom := 0;
3981:
3982: select uom_code
3983: into l_unit_of_issue
3984: from mtl_system_items_vl msiv , mtl_units_of_measure_vl muom
3985: where msiv.inventory_item_id = p_item_id
3986: and msiv.organization_id = p_organization_id
3987: and muom.unit_of_measure = NVL(msiv.unit_of_issue,msiv.primary_unit_of_measure);
3988:

Line 4216: (SELECT 1 FROM mtl_system_items

4212: BEGIN
4213: SELECT 'Y' INTO l_is_lot_control
4214: FROM dual
4215: WHERE exists
4216: (SELECT 1 FROM mtl_system_items
4217: WHERE organization_id = p_organization_id
4218: AND inventory_item_id = p_item_id
4219: AND lot_control_code = 2);
4220: EXCEPTION