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.CSP_MINMAX_PVT dependencies on MTL_SYSTEM_ITEMS

Line 10: , description mtl_system_items.description%TYPE

6: G_TRACE_ON BOOLEAN := FALSE;
7:
8: TYPE minmax_items_rectype IS RECORD
9: ( item VARCHAR2(1000)
10: , description mtl_system_items.description%TYPE
11: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
12: , min_qty mtl_system_items.min_minmax_quantity%TYPE
13: , max_qty mtl_system_items.max_minmax_quantity%TYPE
14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE

Line 11: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE

7:
8: TYPE minmax_items_rectype IS RECORD
9: ( item VARCHAR2(1000)
10: , description mtl_system_items.description%TYPE
11: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
12: , min_qty mtl_system_items.min_minmax_quantity%TYPE
13: , max_qty mtl_system_items.max_minmax_quantity%TYPE
14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE

Line 12: , min_qty mtl_system_items.min_minmax_quantity%TYPE

8: TYPE minmax_items_rectype IS RECORD
9: ( item VARCHAR2(1000)
10: , description mtl_system_items.description%TYPE
11: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
12: , min_qty mtl_system_items.min_minmax_quantity%TYPE
13: , max_qty mtl_system_items.max_minmax_quantity%TYPE
14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE

Line 13: , max_qty mtl_system_items.max_minmax_quantity%TYPE

9: ( item VARCHAR2(1000)
10: , description mtl_system_items.description%TYPE
11: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
12: , min_qty mtl_system_items.min_minmax_quantity%TYPE
13: , max_qty mtl_system_items.max_minmax_quantity%TYPE
14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE

Line 14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE

10: , description mtl_system_items.description%TYPE
11: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
12: , min_qty mtl_system_items.min_minmax_quantity%TYPE
13: , max_qty mtl_system_items.max_minmax_quantity%TYPE
14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
18: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE

Line 15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE

11: , fix_mult mtl_system_items.fixed_lot_multiplier%TYPE
12: , min_qty mtl_system_items.min_minmax_quantity%TYPE
13: , max_qty mtl_system_items.max_minmax_quantity%TYPE
14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
18: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
19: , buying_lead_time mtl_system_items.full_lead_time%TYPE

Line 16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE

12: , min_qty mtl_system_items.min_minmax_quantity%TYPE
13: , max_qty mtl_system_items.max_minmax_quantity%TYPE
14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
18: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
19: , buying_lead_time mtl_system_items.full_lead_time%TYPE
20: , planner mtl_system_items.planner_code%TYPE

Line 17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE

13: , max_qty mtl_system_items.max_minmax_quantity%TYPE
14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
18: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
19: , buying_lead_time mtl_system_items.full_lead_time%TYPE
20: , planner mtl_system_items.planner_code%TYPE
21: , buyer per_all_people_f.full_name%TYPE

Line 18: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE

14: , min_ord_qty mtl_system_items.minimum_order_quantity%TYPE
15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
18: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
19: , buying_lead_time mtl_system_items.full_lead_time%TYPE
20: , planner mtl_system_items.planner_code%TYPE
21: , buyer per_all_people_f.full_name%TYPE
22: , category VARCHAR2(800)

Line 19: , buying_lead_time mtl_system_items.full_lead_time%TYPE

15: , max_ord_qty mtl_system_items.maximum_order_quantity%TYPE
16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
18: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
19: , buying_lead_time mtl_system_items.full_lead_time%TYPE
20: , planner mtl_system_items.planner_code%TYPE
21: , buyer per_all_people_f.full_name%TYPE
22: , category VARCHAR2(800)
23: , category_id mtl_categories.category_id%TYPE

Line 20: , planner mtl_system_items.planner_code%TYPE

16: , fixed_lead_time mtl_system_items.fixed_lead_time%TYPE
17: , variable_lead_time mtl_system_items.variable_lead_time%TYPE
18: , postprocessing_lead_time mtl_system_items.postprocessing_lead_time%TYPE
19: , buying_lead_time mtl_system_items.full_lead_time%TYPE
20: , planner mtl_system_items.planner_code%TYPE
21: , buyer per_all_people_f.full_name%TYPE
22: , category VARCHAR2(800)
23: , category_id mtl_categories.category_id%TYPE
24: , item_id mtl_system_items.inventory_item_id%TYPE

Line 24: , item_id mtl_system_items.inventory_item_id%TYPE

20: , planner mtl_system_items.planner_code%TYPE
21: , buyer per_all_people_f.full_name%TYPE
22: , category VARCHAR2(800)
23: , category_id mtl_categories.category_id%TYPE
24: , item_id mtl_system_items.inventory_item_id%TYPE
25: , lot_ctl mtl_system_items.lot_control_code%TYPE
26: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE
27: , primary_uom mtl_system_items.primary_uom_code%TYPE
28: , accru_acct mtl_parameters.ap_accrual_account%TYPE

Line 25: , lot_ctl mtl_system_items.lot_control_code%TYPE

21: , buyer per_all_people_f.full_name%TYPE
22: , category VARCHAR2(800)
23: , category_id mtl_categories.category_id%TYPE
24: , item_id mtl_system_items.inventory_item_id%TYPE
25: , lot_ctl mtl_system_items.lot_control_code%TYPE
26: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE
27: , primary_uom mtl_system_items.primary_uom_code%TYPE
28: , accru_acct mtl_parameters.ap_accrual_account%TYPE
29: , ipv_acct mtl_parameters.invoice_price_var_account%TYPE

Line 26: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE

22: , category VARCHAR2(800)
23: , category_id mtl_categories.category_id%TYPE
24: , item_id mtl_system_items.inventory_item_id%TYPE
25: , lot_ctl mtl_system_items.lot_control_code%TYPE
26: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE
27: , primary_uom mtl_system_items.primary_uom_code%TYPE
28: , accru_acct mtl_parameters.ap_accrual_account%TYPE
29: , ipv_acct mtl_parameters.invoice_price_var_account%TYPE
30: , budget_acct mtl_system_items.encumbrance_account%TYPE

Line 27: , primary_uom mtl_system_items.primary_uom_code%TYPE

23: , category_id mtl_categories.category_id%TYPE
24: , item_id mtl_system_items.inventory_item_id%TYPE
25: , lot_ctl mtl_system_items.lot_control_code%TYPE
26: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE
27: , primary_uom mtl_system_items.primary_uom_code%TYPE
28: , accru_acct mtl_parameters.ap_accrual_account%TYPE
29: , ipv_acct mtl_parameters.invoice_price_var_account%TYPE
30: , budget_acct mtl_system_items.encumbrance_account%TYPE
31: , charge_acct mtl_system_items.expense_account%TYPE

Line 30: , budget_acct mtl_system_items.encumbrance_account%TYPE

26: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE
27: , primary_uom mtl_system_items.primary_uom_code%TYPE
28: , accru_acct mtl_parameters.ap_accrual_account%TYPE
29: , ipv_acct mtl_parameters.invoice_price_var_account%TYPE
30: , budget_acct mtl_system_items.encumbrance_account%TYPE
31: , charge_acct mtl_system_items.expense_account%TYPE
32: , src_type mtl_system_items.source_type%TYPE
33: , src_org mtl_system_items.source_organization_id%TYPE
34: , src_subinv mtl_system_items.source_subinventory%TYPE

Line 31: , charge_acct mtl_system_items.expense_account%TYPE

27: , primary_uom mtl_system_items.primary_uom_code%TYPE
28: , accru_acct mtl_parameters.ap_accrual_account%TYPE
29: , ipv_acct mtl_parameters.invoice_price_var_account%TYPE
30: , budget_acct mtl_system_items.encumbrance_account%TYPE
31: , charge_acct mtl_system_items.expense_account%TYPE
32: , src_type mtl_system_items.source_type%TYPE
33: , src_org mtl_system_items.source_organization_id%TYPE
34: , src_subinv mtl_system_items.source_subinventory%TYPE
35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE

Line 32: , src_type mtl_system_items.source_type%TYPE

28: , accru_acct mtl_parameters.ap_accrual_account%TYPE
29: , ipv_acct mtl_parameters.invoice_price_var_account%TYPE
30: , budget_acct mtl_system_items.encumbrance_account%TYPE
31: , charge_acct mtl_system_items.expense_account%TYPE
32: , src_type mtl_system_items.source_type%TYPE
33: , src_org mtl_system_items.source_organization_id%TYPE
34: , src_subinv mtl_system_items.source_subinventory%TYPE
35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE

Line 33: , src_org mtl_system_items.source_organization_id%TYPE

29: , ipv_acct mtl_parameters.invoice_price_var_account%TYPE
30: , budget_acct mtl_system_items.encumbrance_account%TYPE
31: , charge_acct mtl_system_items.expense_account%TYPE
32: , src_type mtl_system_items.source_type%TYPE
33: , src_org mtl_system_items.source_organization_id%TYPE
34: , src_subinv mtl_system_items.source_subinventory%TYPE
35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE

Line 34: , src_subinv mtl_system_items.source_subinventory%TYPE

30: , budget_acct mtl_system_items.encumbrance_account%TYPE
31: , charge_acct mtl_system_items.expense_account%TYPE
32: , src_type mtl_system_items.source_type%TYPE
33: , src_org mtl_system_items.source_organization_id%TYPE
34: , src_subinv mtl_system_items.source_subinventory%TYPE
35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
38: , unit_price mtl_system_items.list_price_per_unit%TYPE

Line 35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE

31: , charge_acct mtl_system_items.expense_account%TYPE
32: , src_type mtl_system_items.source_type%TYPE
33: , src_org mtl_system_items.source_organization_id%TYPE
34: , src_subinv mtl_system_items.source_subinventory%TYPE
35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
38: , unit_price mtl_system_items.list_price_per_unit%TYPE
39: , mbf mtl_system_items.planning_make_buy_code%TYPE

Line 36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE

32: , src_type mtl_system_items.source_type%TYPE
33: , src_org mtl_system_items.source_organization_id%TYPE
34: , src_subinv mtl_system_items.source_subinventory%TYPE
35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
38: , unit_price mtl_system_items.list_price_per_unit%TYPE
39: , mbf mtl_system_items.planning_make_buy_code%TYPE
40: , build_in_wip mtl_system_items.build_in_wip_flag%TYPE

Line 37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE

33: , src_org mtl_system_items.source_organization_id%TYPE
34: , src_subinv mtl_system_items.source_subinventory%TYPE
35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
38: , unit_price mtl_system_items.list_price_per_unit%TYPE
39: , mbf mtl_system_items.planning_make_buy_code%TYPE
40: , build_in_wip mtl_system_items.build_in_wip_flag%TYPE
41: , pick_components mtl_system_items.pick_components_flag%TYPE

Line 38: , unit_price mtl_system_items.list_price_per_unit%TYPE

34: , src_subinv mtl_system_items.source_subinventory%TYPE
35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
38: , unit_price mtl_system_items.list_price_per_unit%TYPE
39: , mbf mtl_system_items.planning_make_buy_code%TYPE
40: , build_in_wip mtl_system_items.build_in_wip_flag%TYPE
41: , pick_components mtl_system_items.pick_components_flag%TYPE
42: );

Line 39: , mbf mtl_system_items.planning_make_buy_code%TYPE

35: , purch_flag mtl_system_items.purchasing_enabled_flag%TYPE
36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
38: , unit_price mtl_system_items.list_price_per_unit%TYPE
39: , mbf mtl_system_items.planning_make_buy_code%TYPE
40: , build_in_wip mtl_system_items.build_in_wip_flag%TYPE
41: , pick_components mtl_system_items.pick_components_flag%TYPE
42: );
43:

Line 40: , build_in_wip mtl_system_items.build_in_wip_flag%TYPE

36: , order_flag mtl_system_items.internal_order_enabled_flag%TYPE
37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
38: , unit_price mtl_system_items.list_price_per_unit%TYPE
39: , mbf mtl_system_items.planning_make_buy_code%TYPE
40: , build_in_wip mtl_system_items.build_in_wip_flag%TYPE
41: , pick_components mtl_system_items.pick_components_flag%TYPE
42: );
43:
44: --

Line 41: , pick_components mtl_system_items.pick_components_flag%TYPE

37: , transact_flag mtl_system_items.mtl_transactions_enabled_flag%TYPE
38: , unit_price mtl_system_items.list_price_per_unit%TYPE
39: , mbf mtl_system_items.planning_make_buy_code%TYPE
40: , build_in_wip mtl_system_items.build_in_wip_flag%TYPE
41: , pick_components mtl_system_items.pick_components_flag%TYPE
42: );
43:
44: --
45: -- Start of forward declarations

Line 309: mtl_system_items c,

305: build_in_wip_flag build_in_wip,
306: pick_components_flag pick_components
307: FROM mtl_categories b,
308: mtl_item_categories a,
309: mtl_system_items c,
310: mtl_parameters p
311: WHERE b.category_id = a.category_id
312: AND b.structure_id = :mcat_struct_id
313: AND c.inventory_item_flag = ''Y''

Line 386: mtl_system_items c,

382: build_in_wip_flag,
383: pick_components_flag
384: FROM mtl_categories b,
385: mtl_item_categories a,
386: mtl_system_items c,
387: mtl_parameters p,
388: mtl_secondary_inventories m,
389: mtl_item_sub_inventories s
390: WHERE b.category_id = a.category_id

Line 447: mtl_system_items c,

443: build_in_wip_flag,
444: pick_components_flag
445: FROM mtl_categories b,
446: mtl_item_categories a,
447: mtl_system_items c,
448: mtl_parameters p,
449: per_all_people_f v
450: WHERE b.category_id = a.category_id
451: AND b.structure_id = :mcat_struct_id

Line 532: mtl_system_items c,

528: build_in_wip_flag,
529: pick_components_flag
530: FROM mtl_categories b,
531: mtl_item_categories a,
532: mtl_system_items c,
533: mtl_parameters p,
534: mtl_secondary_inventories m,
535: mtl_item_sub_inventories s,
536: per_all_people_f v

Line 863: FROM mtl_system_items_kfv

859: , p_item_id NUMBER ) RETURN VARCHAR2 IS
860:
861: CURSOR c_item_segments IS
862: SELECT concatenated_segments
863: FROM mtl_system_items_kfv
864: WHERE organization_id = p_org_id
865: AND inventory_item_id = p_item_id;
866:
867: c_item_seg_rec c_item_segments%ROWTYPE;

Line 2808: FROM mtl_system_items msi

2804: IF p_pur_revision = 1
2805: THEN
2806: SELECT revision_qty_control_code
2807: INTO l_item_rev_ctl
2808: FROM mtl_system_items msi
2809: WHERE msi.organization_id = l_orgn_id
2810: AND msi.inventory_item_id = p_item_id;
2811:
2812: print_debug('Rev ctl: ' || to_char(l_item_rev_ctl), 're_po', 9);