DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on MTL_PARAMETERS

Line 90: FROM mtl_parameters

86: SELECT cost_organization_id,
87: primary_cost_method
88: INTO l_cost_org_id,
89: l_primary_cost_method
90: FROM mtl_parameters
91: WHERE organization_id = p_organization_id;
92:
93: -- Get the default cost type
94: l_stmt_num := 15;

Line 475: FROM mtl_parameters

471: cost group id is 1 and it doesn't exist
472: in cst_cost_group_accounts */
473: SELECT organization_id,
474: default_cost_group_id cost_group_id
475: FROM mtl_parameters
476: ) CCGA
477: WHERE CCGA.organization_id = p_organization_id
478: AND CCG.cost_group_id = CCGA.cost_group_id
479: AND NVL(CCG.disable_date, sysdate+1) > sysdate

Line 520: FROM mtl_parameters

516: cost group id is 1 and it doesn't exist
517: in cst_cost_group_accounts */
518: SELECT organization_id,
519: default_cost_group_id cost_group_id
520: FROM mtl_parameters
521: ) CCGA,
522: mtl_interorg_parameters MIP
523: WHERE CCG.cost_group_id = CCGA.cost_group_id
524: AND NVL(CCG.disable_date, sysdate+1) > sysdate

Line 968: mtl_parameters MP

964: cost_type_id
965: FROM cst_inv_qty_temp
966: WHERE organization_id = p_organization_id
967: ) TEMP,
968: mtl_parameters MP
969: WHERE MP.organization_id = p_organization_id;
970:
971: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
972: THEN

Line 1152: mtl_parameters MP,

1148: MS.shipment_line_id
1149: FROM mtl_supply MS,
1150: cst_item_list_temp ITEMS,
1151: cst_cg_list_temp CGS,
1152: mtl_parameters MP,
1153: mtl_interorg_parameters MIP,
1154: mtl_material_transactions MMT,
1155: rcv_shipment_lines RSL,
1156: mtl_system_items MSI_FROM

Line 1652: mtl_parameters MP,

1648: MS.shipment_line_id
1649: FROM mtl_supply MS,
1650: cst_item_list_temp ITEMS,
1651: cst_cg_list_temp CGS,
1652: mtl_parameters MP,
1653: mtl_interorg_parameters MIP,
1654: mtl_material_transactions MMT,
1655: rcv_shipment_lines RSL,
1656: mtl_system_items MSI_FROM

Line 2164: mtl_parameters MP,

2160: )
2161: FROM mtl_supply MS,
2162: cst_item_list_temp ITEMS,
2163: cst_cg_list_temp CGS,
2164: mtl_parameters MP,
2165: mtl_interorg_parameters MIP,
2166: mtl_material_transactions MMT,
2167: rcv_shipment_lines RSL,
2168: mtl_system_items MSI_FROM

Line 2641: mtl_parameters MP,

2637: )
2638: FROM mtl_supply MS,
2639: cst_item_list_temp ITEMS,
2640: cst_cg_list_temp CGS,
2641: mtl_parameters MP,
2642: mtl_interorg_parameters MIP,
2643: mtl_material_transactions MMT,
2644: rcv_shipment_lines RSL,
2645: mtl_system_items MSI_FROM

Line 3179: mtl_parameters MP,

3175: FROM cst_item_list_temp CILT,
3176: cst_cg_list_temp CCLT,
3177: mtl_supply MS,
3178: rcv_transactions RT,
3179: mtl_parameters MP,
3180: po_lines_all POL,
3181: po_line_locations_all POLL,
3182: pjm_project_parameters PPP
3183: WHERE NVL(CILT.inventory_item_id, -1) = NVL(MS.item_id, -1)

Line 3280: mtl_parameters MP,

3276: cst_cg_list_temp CCLT,
3277: rcv_transactions RT,
3278: rcv_transactions PARENT_RT,
3279: rcv_transactions GRPARENT_RT,
3280: mtl_parameters MP,
3281: po_lines_all POL,
3282: po_line_locations_all POLL,
3283: pjm_project_parameters PPP
3284: WHERE NVL(CILT.inventory_item_id, -1) = NVL(POL.item_id, -1)

Line 3423: mtl_parameters MP

3419: CIQT.organization_id,
3420: CIQT.inventory_item_id,
3421: CIQT.cost_type_id
3422: FROM cst_inv_qty_temp CIQT,
3423: mtl_parameters MP
3424: WHERE CIQT.organization_id = p_organization_id
3425: AND MP.organization_id = p_organization_id
3426: AND MP.primary_cost_method = 1
3427: AND CIQT.qty_source NOT IN (1,2,9,10) -- PRIOR SUMMARY, CURRENT SUMMARY,

Line 3621: FROM mtl_parameters MP,

3617: NVL(CIC.material_overhead_cost,0),
3618: NVL(CIC.resource_cost,0),
3619: NVL(CIC.outside_processing_cost,0),
3620: NVL(CIC.overhead_cost,0)
3621: FROM mtl_parameters MP,
3622: cst_item_costs CIC
3623: WHERE MP.organization_id = l_organization_id
3624: AND CIC.organization_id = MP.cost_organization_id
3625: AND CIC.inventory_item_id = l_inventory_item_id

Line 3714: mtl_parameters MP

3710: WHERE qty_source NOT IN (1,2,9,10)
3711: ) CIQT,
3712: cst_quantity_layers CQL,
3713: cst_item_costs CIC,
3714: mtl_parameters MP
3715: WHERE CIC.organization_id = CIQT.organization_id
3716: AND CIC.inventory_item_id = CIQT.inventory_item_id
3717: AND CIC.cost_type_id = CIQT.cost_type_id
3718: AND MP.organization_id = CIQT.organization_id

Line 3808: FROM mtl_parameters MP,

3804: NVL(CIC.material_overhead_cost,0),
3805: NVL(CIC.resource_cost,0),
3806: NVL(CIC.outside_processing_cost,0),
3807: NVL(CIC.overhead_cost,0)
3808: FROM mtl_parameters MP,
3809: cst_item_costs CIC
3810: WHERE MP.organization_id = l_organization_id
3811: AND CIC.organization_id = MP.cost_organization_id
3812: AND CIC.inventory_item_id = l_inventory_item_id

Line 3839: FROM mtl_parameters MP,

3835:
3836: --{BUG#7484428
3837: SELECT nvl(CIC.inventory_asset_flag,2)
3838: INTO l_exp_item_flag
3839: FROM mtl_parameters MP,
3840: cst_item_costs CIC
3841: WHERE MP.organization_id = l_organization_id
3842: AND CIC.organization_id = MP.cost_organization_id
3843: AND CIC.inventory_item_id = l_inventory_item_id

Line 3910: mtl_parameters MP

3906: SUM(NVL(CIC.resource_cost,0)),
3907: SUM(NVL(CIC.outside_processing_cost,0)),
3908: SUM(NVL(CIC.overhead_cost,0))
3909: FROM cst_item_costs CIC,
3910: mtl_parameters MP
3911: WHERE CIC.cost_type_id = 1
3912: AND MP.organization_id = l_organization_id
3913: AND CIC.organization_id = MP.cost_organization_id
3914: AND CIC.inventory_item_id = l_inventory_item_id

Line 3966: mtl_parameters MP

3962: /*
3963: SELECT MIN(CSC.cost_update_id)
3964: INTO l_min_cost_update_id
3965: FROM cst_standard_costs CSC,
3966: mtl_parameters MP
3967: WHERE MP.organization_id = l_organization_id
3968: AND CSC.organization_id = MP.cost_organization_id
3969: AND CSC.inventory_item_id = l_inventory_item_id
3970: AND CSC.standard_cost_revision_date > p_valuation_date;

Line 3985: mtl_parameters MP

3981:
3982: SELECT MAX(CSC.cost_update_id)
3983: INTO l_max_cost_update_id
3984: FROM cst_standard_costs CSC,
3985: mtl_parameters MP
3986: WHERE MP.organization_id = l_organization_id
3987: AND CSC.organization_id = MP.cost_organization_id
3988: AND CSC.inventory_item_id = l_inventory_item_id
3989: AND CSC.standard_cost_revision_date <= p_valuation_date;

Line 4020: mtl_parameters MP

4016: SUM(DECODE(CEC.cost_element_id,3,NVL(CEC.standard_cost,0),0)),
4017: SUM(DECODE(CEC.cost_element_id,4,NVL(CEC.standard_cost,0),0)),
4018: SUM(DECODE(CEC.cost_element_id,5,NVL(CEC.standard_cost,0),0))
4019: FROM cst_elemental_costs CEC,
4020: mtl_parameters MP
4021: WHERE CEC.cost_update_id = l_max_cost_update_id
4022: AND MP.organization_id = l_organization_id
4023: AND CEC.organization_id = MP.cost_organization_id
4024: AND CEC.inventory_item_id = l_inventory_item_id;

Line 4105: FROM mtl_parameters MP,

4101: NVL(CIC.material_overhead_cost,0),
4102: NVL(CIC.resource_cost,0),
4103: NVL(CIC.outside_processing_cost,0),
4104: NVL(CIC.overhead_cost,0)
4105: FROM mtl_parameters MP,
4106: cst_item_costs CIC
4107: WHERE MP.organization_id = l_organization_id
4108: AND CIC.organization_id = MP.cost_organization_id
4109: AND CIC.inventory_item_id = l_inventory_item_id

Line 4183: mtl_parameters MP,

4179: 0,
4180: 0,
4181: 0
4182: FROM cst_inv_qty_temp CIQT,
4183: mtl_parameters MP,
4184: cst_item_costs CIC
4185: WHERE MP.organization_id = CIQT.organization_id
4186: AND MP.primary_cost_method <> 1
4187: AND CIC.organization_id = CIQT.organization_id

Line 4207: FROM mtl_parameters

4203:
4204: l_stmt_num := 55;
4205: SELECT primary_cost_method
4206: INTO l_cost_method
4207: FROM mtl_parameters
4208: WHERE organization_id = p_organization_id;
4209:
4210: l_stmt_num := 60;
4211: INSERT

Line 4256: mtl_parameters MP

4252: CIQT.inventory_item_id,
4253: CIQT.cost_group_id,
4254: MP.primary_cost_method
4255: FROM cst_inv_qty_temp CIQT,
4256: mtl_parameters MP
4257: WHERE MP.organization_id = CIQT.organization_id
4258: AND MP.primary_cost_method <> 1
4259: AND CIQT.qty_source NOT IN (1,2,9,10)
4260: -- PRIOR SUMMARY, CURRENT SUMMARY, RECEIVING, PAST RECEIVING

Line 4607: mtl_parameters MP

4603: CIQT.inventory_item_id,
4604: CIQT.cost_group_id,
4605: MP.primary_cost_method
4606: FROM cst_inv_qty_temp CIQT,
4607: mtl_parameters MP
4608: WHERE MP.organization_id = CIQT.organization_id
4609: AND MP.primary_cost_method <> 1
4610: AND CIQT.qty_source NOT IN (1,2,9,10)
4611: -- PRIOR SUMMARY, CURRENT SUMMARY, RECEIVING, PAST RECEIVING