DBA Data[Home] [Help]

APPS.CSP_MINMAX_PVT dependencies on MTL_PARAMETERS

Line 28: , accru_acct mtl_parameters.ap_accrual_account%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
32: , src_type mtl_system_items.source_type%TYPE

Line 29: , ipv_acct mtl_parameters.invoice_price_var_account%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
32: , src_type mtl_system_items.source_type%TYPE
33: , src_org mtl_system_items.source_organization_id%TYPE

Line 310: mtl_parameters p

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''
314: AND p.organization_id = :org_id

Line 387: mtl_parameters p,

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
391: AND b.structure_id = :mcat_struct_id

Line 448: mtl_parameters p,

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
452: AND c.inventory_item_flag = ''Y''

Line 533: mtl_parameters p,

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
537: WHERE b.category_id = a.category_id