DBA Data[Home] [Help]

APPS.CST_TPRICE_PVT dependencies on MTL_PARAMETERS

Line 131: FROM mtl_parameters mp

127:
128: /* OPM INVCONV sschinch check if this is a process discrete transfer */
129: SELECT MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2)
130: INTO l_pd_txfr_ind
131: FROM mtl_parameters mp
132: WHERE mp.organization_id = p_txn_org_id
133: OR mp.organization_id = p_txf_org_id;
134:
135:

Line 387: FROM mtl_system_items MSI, mtl_parameters MP

383: l_stmt_num := 160;
384:
385: SELECT nvl(MSI.cost_of_sales_account, MP.cost_of_sales_account)
386: INTO l_om_ccid
387: FROM mtl_system_items MSI, mtl_parameters MP
388: WHERE MSI.organization_id = l_from_org
389: AND MSI.inventory_item_id = p_item_id
390: AND MP.organization_id = MSI.organization_id;
391: end if;

Line 488: from mtl_parameters

484: AND cost_element_id = l_cost_element
485: AND cost_type_id = 1
486: AND organization_id =
487: (select cost_organization_id
488: from mtl_parameters
489: where organization_id = l_from_org);
490: else
491: l_stmt_num := 200;
492: