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.CST_INVENTORY_PVT dependencies on MTL_PARAMETERS

Line 127: FROM mtl_parameters

123: SELECT cost_organization_id,
124: primary_cost_method
125: INTO l_cost_org_id,
126: l_primary_cost_method
127: FROM mtl_parameters
128: WHERE organization_id = p_organization_id;
129:
130: -- Set private gloabal variables g_cost_type_id and g_primary_cost_method
131: -- They will be used in procedure Calculate_InventoryCost

Line 513: FROM mtl_parameters

509: cost group id is 1 and it doesn't exist
510: in cst_cost_group_accounts */
511: SELECT organization_id,
512: default_cost_group_id cost_group_id
513: FROM mtl_parameters
514: /* Bug: 7705930
515: This is required for cases when the default
516: cost group id was changed from 1 but there
517: are transactions that belong to this common

Line 569: FROM mtl_parameters

565: cost group id is 1 and it doesn't exist
566: in cst_cost_group_accounts */
567: SELECT organization_id,
568: default_cost_group_id cost_group_id
569: FROM mtl_parameters
570: /* Bug: 7705930
571: This is required for cases when the default
572: cost group id was changed from 1 but there
573: are transactions that belong to this common

Line 779: from mtl_parameters

775:
776: /*Bug 9161102 : FP of Bug 7355767*/
777: l_stmt_num :=5;
778: select primary_cost_method into l_cost_method
779: from mtl_parameters
780: where organization_id = p_organization_id;
781:
782: -- Calculate Current Onhand Quantity
783: l_stmt_num := 10;

Line 1043: mtl_parameters MP

1039: cost_type_id
1040: FROM cst_inv_qty_temp
1041: WHERE organization_id = p_organization_id
1042: ) TEMP,
1043: mtl_parameters MP
1044: WHERE MP.organization_id = p_organization_id;
1045:
1046: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1047: THEN

Line 1228: mtl_parameters MP,

1224: MS.shipment_line_id
1225: FROM mtl_supply MS,
1226: cst_item_list_temp ITEMS,
1227: cst_cg_list_temp CGS,
1228: mtl_parameters MP,
1229: mtl_interorg_parameters MIP,
1230: mtl_material_transactions MMT,
1231: rcv_shipment_lines RSL,
1232: mtl_system_items MSI_FROM

Line 1534: FROM mtl_parameters

1530: AND MMT.costed_flag IS NULL
1531: /* Bug 9764385: Modified the query to include Logical Intransit transactions */
1532: AND ( NVL(MMT.fob_point,MIP.fob_point) = 2
1533: OR MMT.organization_id NOT IN (SELECT organization_id
1534: FROM mtl_parameters
1535: WHERE process_enabled_flag = 'Y')
1536: OR
1537: EXISTS (SELECT 1
1538: FROM mtl_material_transactions

Line 1732: mtl_parameters MP,

1728: MS.shipment_line_id
1729: FROM mtl_supply MS,
1730: cst_item_list_temp ITEMS,
1731: cst_cg_list_temp CGS,
1732: mtl_parameters MP,
1733: mtl_interorg_parameters MIP,
1734: mtl_material_transactions MMT,
1735: rcv_shipment_lines RSL,
1736: mtl_system_items MSI_FROM

Line 2143: FROM mtl_parameters

2139: /* Bug 9764385: Modified the query to include Logical Intransit transactions */
2140: AND ( NVL(MMT.fob_point,MIP.fob_point) = 1
2141: /* Bug 14502148, only consider receiving organization is not OPM organization */
2142: OR MMT.organization_id NOT IN (SELECT organization_id
2143: FROM mtl_parameters
2144: WHERE process_enabled_flag = 'Y')
2145: OR
2146: EXISTS (SELECT 1
2147: FROM mtl_material_transactions

Line 2249: mtl_parameters MP,

2245: )
2246: FROM mtl_supply MS,
2247: cst_item_list_temp ITEMS,
2248: cst_cg_list_temp CGS,
2249: mtl_parameters MP,
2250: mtl_interorg_parameters MIP,
2251: mtl_material_transactions MMT,
2252: rcv_shipment_lines RSL,
2253: mtl_system_items MSI_FROM

Line 2536: FROM mtl_parameters

2532: AND MMT.costed_flag IS NULL
2533: /* Bug 9764385: Modified the query to include Logical Intransit transactions */
2534: AND ( NVL(MMT.fob_point,MIP.fob_point) = 2
2535: OR MMT.organization_id NOT IN (SELECT organization_id
2536: FROM mtl_parameters
2537: WHERE process_enabled_flag = 'Y')
2538: OR
2539: EXISTS (SELECT 1
2540: FROM mtl_material_transactions

Line 2730: mtl_parameters MP,

2726: )
2727: FROM mtl_supply MS,
2728: cst_item_list_temp ITEMS,
2729: cst_cg_list_temp CGS,
2730: mtl_parameters MP,
2731: mtl_interorg_parameters MIP,
2732: mtl_material_transactions MMT,
2733: rcv_shipment_lines RSL,
2734: mtl_system_items MSI_FROM

Line 3120: FROM mtl_parameters

3116: /* Bug 9764385: Modified the query to include Logical Intransit transactions */
3117: AND ( NVL(MMT.fob_point,MIP.fob_point) = 1
3118: /* Bug 14502148, only consider receiving organization is not OPM organization */
3119: OR MMT.organization_id NOT IN (SELECT organization_id
3120: FROM mtl_parameters
3121: WHERE process_enabled_flag = 'Y')
3122: OR
3123: EXISTS (SELECT 1
3124: FROM mtl_material_transactions

Line 3274: mtl_parameters MP,

3270: FROM cst_item_list_temp CILT,
3271: cst_cg_list_temp CCLT,
3272: mtl_supply MS,
3273: rcv_transactions RT,
3274: mtl_parameters MP,
3275: po_lines_all POL,
3276: po_line_locations_all POLL,
3277: pjm_project_parameters PPP
3278: WHERE NVL(CILT.inventory_item_id, -1) = NVL(MS.item_id, -1)

Line 3376: mtl_parameters MP,

3372: cst_cg_list_temp CCLT,
3373: rcv_transactions RT,
3374: rcv_transactions PARENT_RT,
3375: rcv_transactions GRPARENT_RT,
3376: mtl_parameters MP,
3377: po_lines_all POL,
3378: po_line_locations_all POLL,
3379: pjm_project_parameters PPP
3380: WHERE NVL(CILT.inventory_item_id, -1) = NVL(POL.item_id, -1)

Line 3523: mtl_parameters MP

3519: CIQT.organization_id,
3520: CIQT.inventory_item_id,
3521: CIQT.cost_type_id
3522: FROM cst_inv_qty_temp CIQT,
3523: mtl_parameters MP
3524: WHERE CIQT.organization_id = p_organization_id
3525: AND MP.organization_id = p_organization_id
3526: AND MP.primary_cost_method = 1
3527: AND CIQT.qty_source NOT IN (1,2,9,10) -- PRIOR SUMMARY, CURRENT SUMMARY,

Line 3673: mtl_parameters MP

3669: SUM(NVL(CIC.resource_cost,0)),
3670: SUM(NVL(CIC.outside_processing_cost,0)),
3671: SUM(NVL(CIC.overhead_cost,0))
3672: FROM cst_item_costs CIC,
3673: mtl_parameters MP
3674: WHERE CIC.cost_type_id = 1
3675: AND MP.organization_id = p_organization_id
3676: AND CIC.organization_id = MP.cost_organization_id
3677: AND CIC.inventory_item_id = p_inventory_item_id

Line 3800: FROM mtl_parameters MP,

3796: NVL(CIC.material_overhead_cost,0),
3797: NVL(CIC.resource_cost,0),
3798: NVL(CIC.outside_processing_cost,0),
3799: NVL(CIC.overhead_cost,0)
3800: FROM mtl_parameters MP,
3801: cst_item_costs CIC
3802: WHERE MP.organization_id = l_organization_id
3803: AND CIC.organization_id = MP.cost_organization_id
3804: AND CIC.inventory_item_id = l_inventory_item_id

Line 3893: mtl_parameters MP

3889: WHERE qty_source NOT IN (1,2,9,10)
3890: ) CIQT,
3891: cst_quantity_layers CQL,
3892: cst_item_costs CIC,
3893: mtl_parameters MP
3894: WHERE CIC.organization_id = CIQT.organization_id
3895: AND CIC.inventory_item_id = CIQT.inventory_item_id
3896: AND CIC.cost_type_id = CIQT.cost_type_id
3897: AND MP.organization_id = CIQT.organization_id

Line 3987: FROM mtl_parameters MP,

3983: NVL(CIC.material_overhead_cost,0),
3984: NVL(CIC.resource_cost,0),
3985: NVL(CIC.outside_processing_cost,0),
3986: NVL(CIC.overhead_cost,0)
3987: FROM mtl_parameters MP,
3988: cst_item_costs CIC
3989: WHERE MP.organization_id = l_organization_id
3990: AND CIC.organization_id = MP.cost_organization_id
3991: AND CIC.inventory_item_id = l_inventory_item_id

Line 4013: FROM mtl_parameters MP,

4009:
4010: --{BUG#7484428
4011: SELECT nvl(CIC.inventory_asset_flag,2)
4012: INTO l_exp_item_flag
4013: FROM mtl_parameters MP,
4014: cst_item_costs CIC
4015: WHERE MP.organization_id = l_organization_id
4016: AND CIC.organization_id = MP.cost_organization_id
4017: AND CIC.inventory_item_id = l_inventory_item_id

Line 4041: mtl_parameters MP

4037:
4038: SELECT MIN(CSC.cost_update_id)
4039: INTO l_min_cost_update_id
4040: FROM cst_standard_costs CSC,
4041: mtl_parameters MP
4042: WHERE MP.organization_id = l_organization_id
4043: AND CSC.organization_id = MP.cost_organization_id
4044: AND CSC.inventory_item_id = l_inventory_item_id
4045: AND CSC.standard_cost_revision_date > p_valuation_date;

Line 4060: mtl_parameters MP

4056: -- Yes. Figure out the prior cost update
4057: SELECT MAX(CSC.cost_update_id)
4058: INTO l_max_cost_update_id
4059: FROM cst_standard_costs CSC,
4060: mtl_parameters MP
4061: WHERE MP.organization_id = l_organization_id
4062: AND CSC.organization_id = MP.cost_organization_id
4063: AND CSC.inventory_item_id = l_inventory_item_id
4064: AND CSC.standard_cost_revision_date <= p_valuation_date;

Line 4072: mtl_parameters MP

4068: CURSOR csc_cur
4069: IS
4070: SELECT CSC.cost_update_id
4071: FROM cst_standard_costs CSC,
4072: mtl_parameters MP
4073: WHERE MP.organization_id = l_organization_id
4074: AND CSC.organization_id = MP.cost_organization_id
4075: AND CSC.inventory_item_id = l_inventory_item_id
4076: AND CSC.standard_cost_revision_date <= p_valuation_date

Line 4118: mtl_parameters MP

4114: SUM(DECODE(CEC.cost_element_id,3,NVL(CEC.standard_cost,0),0)),
4115: SUM(DECODE(CEC.cost_element_id,4,NVL(CEC.standard_cost,0),0)),
4116: SUM(DECODE(CEC.cost_element_id,5,NVL(CEC.standard_cost,0),0))
4117: FROM cst_elemental_costs CEC,
4118: mtl_parameters MP
4119: WHERE CEC.cost_update_id = l_max_cost_update_id
4120: AND MP.organization_id = l_organization_id
4121: AND CEC.organization_id = MP.cost_organization_id
4122: AND CEC.inventory_item_id = l_inventory_item_id;

Line 4212: FROM mtl_parameters MP,

4208: NVL(CIC.material_overhead_cost,0),
4209: NVL(CIC.resource_cost,0),
4210: NVL(CIC.outside_processing_cost,0),
4211: NVL(CIC.overhead_cost,0)
4212: FROM mtl_parameters MP,
4213: cst_item_costs CIC
4214: WHERE MP.organization_id = l_organization_id
4215: AND CIC.organization_id = MP.cost_organization_id
4216: AND CIC.inventory_item_id = l_inventory_item_id

Line 4298: mtl_parameters MP

4294: FROM cst_inv_qty_temp
4295: WHERE qty_source NOT IN (1,2,9,10)
4296: ) CIQT,
4297: cst_item_costs CIC,
4298: mtl_parameters MP
4299: WHERE CIC.organization_id = CIQT.organization_id
4300: AND CIC.inventory_item_id = CIQT.inventory_item_id
4301: AND CIC.cost_type_id = CIQT.cost_type_id
4302: AND MP.organization_id = CIQT.organization_id

Line 4339: mtl_parameters MP,

4335: 0,
4336: 0,
4337: 0
4338: FROM cst_inv_qty_temp CIQT,
4339: mtl_parameters MP,
4340: cst_item_costs CIC
4341: WHERE MP.organization_id = CIQT.organization_id
4342: AND MP.primary_cost_method <> 1
4343: AND CIC.organization_id = CIQT.organization_id

Line 4363: FROM mtl_parameters

4359:
4360: l_stmt_num := 55;
4361: SELECT primary_cost_method
4362: INTO l_cost_method
4363: FROM mtl_parameters
4364: WHERE organization_id = p_organization_id;
4365:
4366: l_stmt_num := 60;
4367: /* Bug 9764385: Modified the query to include Logical Intransit transactions */

Line 4631: mtl_parameters MP

4627: CIQT.inventory_item_id,
4628: CIQT.cost_group_id,
4629: MP.primary_cost_method
4630: FROM cst_inv_qty_temp CIQT,
4631: mtl_parameters MP
4632: WHERE MP.organization_id = CIQT.organization_id
4633: AND MP.primary_cost_method <> 1
4634: AND CIQT.qty_source NOT IN (1,2,9,10)
4635: -- PRIOR SUMMARY, CURRENT SUMMARY, RECEIVING, PAST RECEIVING