DBA Data[Home] [Help]

APPS.INV_INVTRHAN_XMLP_PKG dependencies on MTL_PARAMETERS

Line 442: mtl_parameters mp

438: 0 cur_qty,
439: -sum(primary_quantity) target_qty
440: from mtl_material_transactions mmt,
441: mtl_txn_source_types mtst,
442: mtl_parameters mp
443: where mmt.organization_id = ' || VAR_ORG || '
444: and mp.organization_id = ' || VAR_ORG || '
445: /*and transaction_date >= to_date(''' || HIST_DATE || ''' , ''DD-MON-RRRR'' ) + 1 --GSCC change hist_date + 1 */
446: and transaction_date >= ''' || L_HIST_DATE || ''' --GSCC change hist_date + 1

Line 540: mtl_parameters mp,

536: 0 cur_qty,
537: -sum(primary_quantity) target_qty
538: from mtl_material_transactions mmt,
539: mtl_txn_source_types mtst,
540: mtl_parameters mp,
541: cst_item_costs_for_gl_view cst
542: where mmt.organization_id = ' || VAR_ORG || '
543: and mp.organization_id = ' || VAR_ORG || '
544: and cst.organization_id = ' || VAR_ORG || '

Line 745: MTL_PARAMETERS

741: SELECT
742: PRIMARY_COST_METHOD
743: INTO COST_TYPE
744: FROM
745: MTL_PARAMETERS
746: WHERE ORGANIZATION_ID = ORG_ID;
747: RETURN (COST_TYPE);
748: EXCEPTION
749: WHEN NO_DATA_FOUND THEN