DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_TRANSACTION_TYPES

Line 875: FROM mtl_transaction_types mtt

871: SELECT transaction_action_id,
872: transaction_source_type_id
873: INTO g_transaction_action_id,
874: g_transaction_source_type_id
875: FROM mtl_transaction_types mtt
876: WHERE mtt.transaction_type_id = p_trx_type_id;
877: g_isa_trx_type_id := p_trx_type_id;
878: ELSE
879: g_transaction_action_id := NULL;

Line 947: from mtl_transaction_types

943: if p_trx_status_enabled is null then
944: if p_trx_type_id <> nvl(g_isa_trx_type_id,-9999) THEN
945: select status_control_flag
946: into g_isa_trx_status_enabled
947: from mtl_transaction_types
948: where transaction_type_id = p_trx_type_id;
949: g_isa_trx_type_id := p_trx_type_id;
950: end if;
951: l_trx_status_enabled := g_isa_trx_status_enabled;

Line 2231: from mtl_transaction_types

2227: BEGIN
2228:
2229: select transaction_action_id
2230: into l_action_id
2231: from mtl_transaction_types
2232: where transaction_type_id = p_trx_type_id;
2233:
2234: return l_action_id;
2235: