APPS.INVPCOII dependencies on MTL_PARAMETERS

Line 77: from mtl_parameters

73: select primary_cost_method,
74: cost_organization_id
75: into l_cost_type_id,
76: l_cost_organization_id
77: from mtl_parameters
78: where organization_id = l_organization_id;
79:
80: /* Material Sub element */
81: If (l_material_sub_elem is not NULL) Then

Line 331: from mtl_parameters mp

327: NULL, -- attribute12
328: NULL, -- attribute13
329: NULL, -- attribute14
330: NULL -- attribute15
331: from mtl_parameters mp
332: where mp.organization_id = i_organization_id;
333:
334: Select cst_lists_s.nextval
335: INTO cost_update

Line 350: FROM cst_item_cost_details cicd, mtl_parameters mp

346: I_INVENTORY_ITEM_ID,
347: SYSDATE, I_USER_ID,
348: SYSDATE, I_USER_ID, I_LOGIN_ID,
349: SYSDATE, NVL(SUM(cicd.item_cost),0)
350: FROM cst_item_cost_details cicd, mtl_parameters mp
351: WHERE cicd.ORGANIZATION_ID = I_ORGANIZATION_ID
352: AND cicd.INVENTORY_ITEM_ID = I_INVENTORY_ITEM_ID
353: AND cicd.COST_TYPE_ID = mp.primary_cost_method
354: AND mp.ORGANIZATION_ID = I_ORGANIZATION_ID;

Line 366: FROM cst_item_cost_details cicd, mtl_parameters mp

362: I_INVENTORY_ITEM_ID, cicd.cost_element_id,
363: SYSDATE, I_USER_ID,
364: SYSDATE, I_USER_ID, I_LOGIN_ID,
365: NVL(SUM(cicd.item_cost),0)
366: FROM cst_item_cost_details cicd, mtl_parameters mp
367: WHERE cicd.ORGANIZATION_ID = I_ORGANIZATION_ID
368: AND cicd.INVENTORY_ITEM_ID = I_INVENTORY_ITEM_ID
369: AND cicd.COST_TYPE_ID = mp.primary_cost_method
370: AND mp.ORGANIZATION_ID = I_ORGANIZATION_ID

Line 427: from mtl_parameters

423: /* Get the cost type id, either frozen or average */
424: l_location := 400;
425: select primary_cost_method
426: into l_cost_type_id
427: from mtl_parameters
428: where organization_id = I_ORGANIZATION_ID;
429:
430: /* Moved call to CSTPIICC.CSTPIICI before Material Cost Processing for bug 3219632 */
431: /* Create default costing information */

Line 568: mtl_parameters mp

564: mp.organization_id,
565: mp.master_organization_id,
566: mp.cost_organization_id
567: from mtl_system_items_interface msii,
568: mtl_parameters mp
569: where msii.process_flag = 4
570: and msii.transaction_type = 'CREATE'
571: and msii.costing_enabled_flag = 'Y'
572: and msii.organization_id = mp.organization_id

Line 592: mtl_parameters mp

588: mp.organization_id,
589: mp.master_organization_id,
590: mp.cost_organization_id
591: from mtl_system_items_interface msii,
592: mtl_parameters mp
593: where msii.process_flag = 4
594: and msii.transaction_type = 'CREATE'
595: and msii.costing_enabled_flag = 'Y'
596: and msii.organization_id = mp.organization_id

Line 617: mtl_parameters mp

613: mp.organization_id,
614: mp.master_organization_id,
615: mp.cost_organization_id
616: from mtl_system_items_interface msii,
617: mtl_parameters mp
618: where msii.process_flag = 4
619: and msii.transaction_type = 'CREATE'
620: and msii.costing_enabled_flag = 'Y'
621: and msii.organization_id = mp.organization_id