APPS.INV_MGD_MVT_SETUP_MDTR dependencies on MTL_STAT_TYPE_USAGES

Line 123: , MTL_STAT_TYPE_USAGES mstat

119: FROM
120: GL_PERIODS glp
121: , GL_PERIODS glp1
122: , gl_ledger_le_v gllv
123: , MTL_STAT_TYPE_USAGES mstat
124: WHERE glp.period_set_name = mstat.period_set_name
125: AND glp1.period_set_name = mstat.period_set_name
126: AND glp.period_name = mstat.start_period_name
127: AND glp1.period_name = NVL(mstat.end_period_name,

Line 233: MTL_STAT_TYPE_USAGES mstat

229: , mstat.pending_invoice_days
230: , mstat.prior_invoice_days
231: , mstat.triangulation_mode
232: FROM
233: MTL_STAT_TYPE_USAGES mstat
234: WHERE mstat.legal_entity_id = p_legal_entity_id;
235:
236: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
237: THEN

Line 347: , MTL_STAT_TYPE_USAGES mstat

343: FROM
344: GL_PERIODS glp
345: , GL_PERIODS glp1
346: , gl_ledger_le_v gllv
347: , MTL_STAT_TYPE_USAGES mstat
348: WHERE glp.period_set_name = glp1.period_set_name
349: AND glp.period_set_name = mstat.period_set_name
350: AND glp1.period_set_name = mstat.period_set_name
351: AND glp.period_type = mstat.period_type

Line 478: -- Check if there is an entry in the MTL_STAT_TYPE_USAGES table for

474: END IF;
475:
476: -- If the dispatch and destination territory codes are within the same
477: -- economic zones then the transaction is of usage_type INTERNAL.
478: -- Check if there is an entry in the MTL_STAT_TYPE_USAGES table for
479: -- usage_type of INTERNAL, if there is then we go ahead and process
480: -- the transaction, otherwise get the next record from the c_shp loop.
481:
482: IF l_movement_transaction.usage_type = 'INTERNAL'

Line 496: -- Check if there is an entry in the MTL_STAT_TYPE_USAGES table for

492: END IF;
493:
494: -- If the dispatch and destination territory codes are in different
495: -- economic zones then the transaction is of usage_type EXTERNAL.
496: -- Check if there is an entry in the MTL_STAT_TYPE_USAGES table for
497: -- usage_type of EXTERNAL, if there is then we go ahead and process
498: -- the transaction, otherwise get the next record from the c_shp loop.
499:
500: ELSIF l_movement_transaction.usage_type = 'EXTERNAL'

Line 599: FROM mtl_stat_type_usages

595: , x_movement_stat_usages_rec.period_set_name
596: , x_movement_stat_usages_rec.attribute_rule_set_code
597: , x_movement_stat_usages_rec.alt_uom_rule_set_code
598: , x_movement_stat_usages_rec.returns_processing
599: FROM mtl_stat_type_usages
600: WHERE legal_entity_id = p_legal_entity_id
601: AND zone_code = p_economic_zone_code
602: AND usage_type = p_usage_type
603: AND stat_type = p_stat_type;