APPS.INVTVTUS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

		delete from mtl_summary_temp
		where session_id = sessionid;

Line: 26

		select fc.precision into prc
		from org_organization_definitions ood,
		gl_sets_of_books sob,
		fnd_currencies fc
		where ood.organization_id = orgid
		and ood.set_of_books_id = sob.set_of_books_id
		and fc.currency_code = sob.currency_code;

Line: 41

/*Bug2712883 : The insert statements having cg_id in their where clause is modified so as to include NVL's on both sides */
		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 transaction_source_type_name,
		 transaction_type_name,
		 transaction_action_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SRCTYPE_TXNTYPE_SUMMARY',
		mtst.transaction_source_type_name,
		mtt.transaction_type_name,
		ml.meaning,
		cratio*sum(mmt.primary_quantity),
		round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
		from mtl_material_transactions mmt,
			mfg_lookups ml,
			mtl_txn_source_types mtst,
			mtl_transaction_types mtt
		where mmt.inventory_item_id = invid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
		and mmt.organization_id = orgid
		and mmt.transaction_date >= NVL(sdate,mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
		and mtst.transaction_source_type_id = mmt.transaction_source_type_id
		and mtt.transaction_type_id = mmt.transaction_type_id
		and ml.lookup_code = mmt.transaction_action_id + 0
		and ml.lookup_type = 'MTL_TRANSACTION_ACTION'
                and mmt.transaction_action_id NOT IN (24,30,50,51,52)  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
		group by mtst.transaction_source_type_name,
		 mtt.transaction_type_name, ml.meaning;

Line: 83

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 transaction_source_type_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SOURCE_TYPES_SUMMARY',
		mst.transaction_source_type_name,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.transaction_source_type_name;

Line: 107

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 transaction_type_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'TXN_TYPES_SUMMARY',
		mst.transaction_type_name,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.transaction_type_name;

Line: 131

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 transaction_action_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'TXN_ACTION_SUMMARY',
		mst.transaction_action_name,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.transaction_action_name;

Line: 156

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUBINVENTORY_SUMMARY',
		mmt.subinventory_code,
		cratio*sum(mmt.primary_quantity),
		round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
		from mtl_material_transactions mmt
		where mmt.inventory_item_id = invid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
		and mmt.organization_id = orgid
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
                and mmt.transaction_action_id NOT IN (24,30,50,51,52)  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
		group by mmt.subinventory_code;

Line: 185

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 locator_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUBINVENTORY_LOCATOR_SUMMARY',
		mmt.subinventory_code,
		mmt.locator_id,
		cratio*sum(mmt.primary_quantity),
		round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
		from mtl_material_transactions mmt
		where mmt.inventory_item_id = invid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
		and mmt.organization_id = orgid
		and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
                and mmt.transaction_action_id NOT IN (24,30,50,51,52)  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
		group by mmt.subinventory_code, mmt.locator_id;

Line: 216

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUBINVENTORY_SUMMARY',
		mst.subinventory,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SUBINVENTORY_LOCATOR_SUMMARY'
		and session_id = sessionid
		group by mst.subinventory;

Line: 243

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 cost_group_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUB_COST_GROUP_SUMMARY',
		mmt.subinventory_code,
		mmt.cost_group_id,
		cratio*sum(mmt.primary_quantity),
		round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
		from mtl_material_transactions mmt
		where mmt.inventory_item_id = invid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
		and mmt.organization_id = orgid
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
                and mmt.transaction_action_id NOT IN (24,30,50,51,52)  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
		group by mmt.subinventory_code, mmt.cost_group_id;

Line: 274

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 cost_group_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'COST_GROUP_SUMMARY',
		mst.cost_group_id,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SUB_COST_GROUP_SUMMARY'
		and session_id = sessionid
		group by mst.cost_group_id;

Line: 299

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_qty,
		 net_val,
		 num_txns,
		 locator_id) /* This is populated for ordering purposes */
		select
		sessionid,
		'TOTALS',
		nvl(cratio*sum(mmt.primary_quantity),0),
		round(nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),prc),
		nvl(sum(1),0),
		1
		from mtl_material_transactions mmt
		where mmt.inventory_item_id = invid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
		and mmt.organization_id = orgid
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
		and mmt.primary_quantity > 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52);  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */

Line: 324

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_qty,
		 net_val,
		 num_txns,
		 locator_id) /* This is populated for ordering purposes */
		select
		sessionid,
		'TOTALS',
		nvl(abs(cratio*sum(mmt.primary_quantity)),0),
		round(nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),prc),
		nvl(sum(1),0),
		2
		from mtl_material_transactions mmt
		where mmt.inventory_item_id = invid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
		and mmt.organization_id = orgid
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
		and mmt.primary_quantity < 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52);  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */

Line: 349

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_qty,
		 net_val,
		 num_txns,
		 locator_id) /* This is populated for ordering purposes */
		select
		sessionid,
		'TOTALS',
		sum(mst.net_qty),
		sum(mst.net_val),
		null,
		3
		from mtl_summary_temp mst
		where mst.summary_type='TXN_ACTION_SUMMARY'
		and session_id = sessionid;

Line: 388

		delete from mtl_summary_temp where session_id = sessionid;

Line: 393

		select fc.precision into prc
		from org_organization_definitions ood,
		gl_sets_of_books sob,
		fnd_currencies fc
		where ood.organization_id = orgid
		and ood.set_of_books_id = sob.set_of_books_id
		and fc.currency_code = sob.currency_code;

Line: 405

		/* We are inserting transaction action as well
		   for later summarization */
		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 inventory_item_id,
		 organization_id,
		 transaction_source_type_name,
		 transaction_type_name,
		 transaction_action_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'ITEM_SRCTYPE_TXNTYPE_SUMMARY',
		mmt.inventory_item_id,
		min(mmt.organization_id),
		mtst.transaction_source_type_name,
		mtt.transaction_type_name,
		ml.meaning,
		sum(mmt.primary_quantity),
		round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
		sum(1),
		sum(abs(mmt.primary_quantity)),
		round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
		from mtl_material_transactions mmt,
			mtl_txn_source_types mtst,
			mfg_lookups ml,
			mtl_transaction_types mtt
		where mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
		and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and mmt.subinventory_code = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and mtst.transaction_source_type_id = mmt.transaction_source_type_id
		and mtt.transaction_type_id = mmt.transaction_type_id
		and ml.lookup_type = 'MTL_TRANSACTION_ACTION'
		and ml.lookup_code = mmt.transaction_action_id + 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52)  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
		group by mmt.inventory_item_id,
			mtst.transaction_source_type_name,
			mtt.transaction_type_name,
			ml.meaning;

Line: 453

	   	insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 inventory_item_id,
		 organization_id,
		 transaction_source_type_name,
		 transaction_type_name,
		 transaction_action_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'ITEM_SRCTYPE_TXNTYPE_SUMMARY',
		mmt.inventory_item_id,
		min(mmt.organization_id),
		mtst.transaction_source_type_name,
		mtt.transaction_type_name,
		ml.meaning,
		sum(mmt.primary_quantity),
		round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
		sum(1),
		sum(abs(mmt.primary_quantity)),
		round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
		from mtl_material_transactions mmt,
			mtl_txn_source_types mtst,
			mfg_lookups ml,
			mtl_transaction_types mtt
		where mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
		and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and mmt.subinventory_code = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and exists ( select 'X'
			from mtl_item_categories mic
			where mic.category_set_id = nvl(catsetid, mic.category_set_id)
			and mic.category_id = nvl(catid, mic.category_id)
			and mic.inventory_item_id = mmt.inventory_item_id
			and mic.organization_id = orgid)
		and mtst.transaction_source_type_id = mmt.transaction_source_type_id
		and mtt.transaction_type_id = mmt.transaction_type_id
		and ml.lookup_type = 'MTL_TRANSACTION_ACTION'
		and ml.lookup_code = mmt.transaction_action_id + 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52)  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
		group by mmt.inventory_item_id,
			mtst.transaction_source_type_name,
			mtt.transaction_type_name,
			ml.meaning;

Line: 507

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 inventory_item_id,
		 organization_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		 select
		sessionid,
		'ITEM_SUMMARY',
		mst.inventory_item_id,
		min(mst.organization_id),
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.inventory_item_id;

Line: 533

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 inventory_item_id,
		 organization_id,
		 transaction_source_type_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'ITEM_SRCTYPE_SUMMARY',
		mst.inventory_item_id,
		min(mst.organization_id),
		mst.transaction_source_type_name,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.inventory_item_id, mst.transaction_source_type_name;

Line: 561

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 inventory_item_id,
		 organization_id,
		 transaction_type_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'ITEM_TXN_TYPES_SUMMARY',
		mst.inventory_item_id,
		min(mst.organization_id),
		mst.transaction_type_name,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.inventory_item_id, mst.transaction_type_name;

Line: 589

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 inventory_item_id,
		 organization_id,
		 transaction_action_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'ITEM_TXN_ACTION_SUMMARY',
		mst.inventory_item_id,
		min(mst.organization_id),
		mst.transaction_action_name,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.inventory_item_id, mst.transaction_action_name;

Line: 616

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 cost_group_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUB_COST_GROUP_SUMMARY',
		mmt.subinventory_code,
		mmt.cost_group_id,
		cratio*sum(mmt.primary_quantity),
		round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
		from mtl_material_transactions mmt
		where mmt.subinventory_code = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.transaction_action_id NOT IN (24,30,50,51,52)  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
		group by mmt.subinventory_code, mmt.cost_group_id;

Line: 647

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 cost_group_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'COST_GROUP_SUMMARY',
		mst.cost_group_id,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SUB_COST_GROUP_SUMMARY'
		and session_id = sessionid
		group by mst.cost_group_id;

Line: 673

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_val,
		 num_txns,
		 locator_id)
		select
		sessionid,
		'TOTALS',
		round(nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),prc),
		nvl(sum(1),0),
		1
		from mtl_material_transactions mmt
		where mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and mmt.subinventory_code = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and mmt.primary_quantity > 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52);  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */

Line: 695

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_val,
		 num_txns,
		 locator_id) /* This is populated for ordering purposes */
		select
		sessionid,
		'TOTALS',
		round(nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),prc),
		nvl(sum(1),0),
		2
		from mtl_material_transactions mmt
		where mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and mmt.subinventory_code = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and mmt.primary_quantity < 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52);  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */

Line: 717

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_val,
		 num_txns,
		 locator_id)
		select
		sessionid,
		'TOTALS',
		round(nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),prc),
		nvl(sum(1),0),
		1
		from mtl_material_transactions mmt
		where mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and mmt.subinventory_code = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and exists ( select 'X'
			from mtl_item_categories mic
			where mic.category_set_id = nvl(catsetid, mic.category_set_id)
			and mic.category_id = nvl(catid, mic.category_id)
			and mic.inventory_item_id = mmt.inventory_item_id
			and mic.organization_id = orgid)
		and mmt.primary_quantity > 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52);  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */

Line: 745

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_val,
		 num_txns,
		 locator_id) /* This is populated for ordering purposes */
		select
		sessionid,
		'TOTALS',
		round(nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),prc),
		nvl(sum(1),0),
		2
		from mtl_material_transactions mmt
		where mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and mmt.subinventory_code = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and exists ( select 'X'
			from mtl_item_categories mic
			where mic.category_set_id = nvl(catsetid, mic.category_set_id)
			and mic.category_id = nvl(catid, mic.category_id)
			and mic.inventory_item_id = mmt.inventory_item_id
			and mic.organization_id = orgid)
		and mmt.primary_quantity < 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52);  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */

Line: 774

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_val,
		 num_txns,
		 locator_id) /* This is populated for ordering purposes */
		select
		sessionid,
		'TOTALS',
		sum(mst.net_val),
		null,
		3
		from mtl_summary_temp mst
		where summary_type = 'ITEM_SUMMARY'
		and session_id = sessionid;

Line: 811

		delete from mtl_summary_temp where session_id = sessionid;

Line: 815

		select fc.precision into prc
		from org_organization_definitions ood,
		gl_sets_of_books sob,
		fnd_currencies fc
		where ood.organization_id = orgid
		and ood.set_of_books_id = sob.set_of_books_id
		and fc.currency_code = sob.currency_code;

Line: 828

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 transaction_source_type_name,
		 transaction_type_name,
		 transaction_action_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SRCTYPE_TXNTYPE_SUMMARY',
		mtst.transaction_source_type_name,
		mtt.transaction_type_name,
		ml.meaning,
		cratio*sum(mmt.primary_quantity),
		round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
		from mtl_material_transactions mmt,
			mtl_txn_source_types mtst,
			mtl_transaction_types mtt,
			mfg_lookups ml
		where mmt.inventory_item_id = invid
		and mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
		and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
		and mtst.transaction_source_type_id = mmt.transaction_source_type_id
		and mtt.transaction_type_id = mmt.transaction_type_id
		and mmt.subinventory_code||'' = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and ml.lookup_code = mmt.transaction_action_id + 0
		and ml.lookup_type = 'MTL_TRANSACTION_ACTION'
                and mmt.transaction_action_id NOT IN (24,30,50,51,52)  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
		group by mtst.transaction_source_type_name, mtt.transaction_type_name, ml.meaning;

Line: 870

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 transaction_source_type_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SOURCE_TYPES_SUMMARY',
		mst.transaction_source_type_name,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.transaction_source_type_name;

Line: 896

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 transaction_type_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'TXN_TYPES_SUMMARY',
		mst.transaction_type_name,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.transaction_type_name;

Line: 921

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 transaction_action_name,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'TXN_ACTION_SUMMARY',
		mst.transaction_action_name,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SRCTYPE_TXNTYPE_SUMMARY'
		and session_id = sessionid
		group by mst.transaction_action_name;

Line: 945

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 cost_group_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUB_COST_GROUP_SUMMARY',
		mmt.subinventory_code,
		mmt.cost_group_id,
		cratio*sum(mmt.primary_quantity),
		round(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),prc),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		round(sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity)),prc)
		from mtl_material_transactions mmt
		where mmt.subinventory_code = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and mmt.organization_id = orgid
		and mmt.inventory_item_id = invid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
                and mmt.transaction_action_id NOT IN (24,30,50,51,52)  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */
		group by mmt.subinventory_code, mmt.cost_group_id;

Line: 978

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 cost_group_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'COST_GROUP_SUMMARY',
		mst.cost_group_id,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SUB_COST_GROUP_SUMMARY'
		and session_id = sessionid
		group by mst.cost_group_id;

Line: 1003

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_qty,
		 net_val,
		 num_txns,
		 locator_id) /* This is populated for ordering purposes */
		select
		sessionid,
		'TOTALS',
		nvl(cratio*sum(mmt.primary_quantity),0),
		round(nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),prc),
		nvl(sum(1),0),
		1
		from mtl_material_transactions mmt
		where mmt.inventory_item_id = invid
		and mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
		and mmt.subinventory_code||'' = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and mmt.primary_quantity > 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52);  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */

Line: 1030

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_qty,
		 net_val,
		 num_txns,
		 locator_id) /* This is populated for ordering purposes */
		select
		sessionid,
		'TOTALS',
		nvl(abs(cratio*sum(mmt.primary_quantity)),0),
		round(nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),prc),
		nvl(sum(1),0),
		2
		from mtl_material_transactions mmt
		where mmt.inventory_item_id = invid
		and mmt.organization_id = orgid
		and NVL(mmt.cost_group_id,-9999) = NVL(NVL(cg_id,mmt.cost_group_id),-9999)
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
		and (mmt.revision = nvl(rev, mmt.revision) or mmt.revision is null)
		and mmt.subinventory_code||'' = sub
		and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
		and mmt.primary_quantity < 0
                and mmt.transaction_action_id NOT IN (24,30,50,51,52);  /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */

Line: 1056

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 net_qty,
		 net_val,
		 num_txns,
		 locator_id) /* This is populated for ordering purposes */
		select
		sessionid,
		'TOTALS',
		sum(mst.net_qty),
		sum(mst.net_val),
		null,
		3
		from mtl_summary_temp mst
		where mst.summary_type = 'TXN_ACTION_SUMMARY'
		and session_id = sessionid;

Line: 1090

                delete from mtl_summary_temp where session_id = sessionid;

Line: 1093

                /* We are inserting transaction action as well
                   for later summarization */
 /*               insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 inventory_item_id,
                 organization_id,
                 transaction_source_type_name,
                 transaction_type_name,
                 transaction_action_name,
                 net_qty,
                 net_val,
                 num_txns,
                 abs_qty,
                 abs_val)
                select
                sessionid,
                'ITEM_SRCTYPE_TXNTYPE_SUMMARY',
                mmt.inventory_item_id,
                min(mmt.organization_id),
                mtst.transaction_source_type_name,
                mtt.transaction_type_name,
                ml.meaning,
                sum(mmt.primary_quantity),
                sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
                sum(1),
                sum(abs(mmt.primary_quantity)),
                sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
                from mtl_material_transactions mmt,
                        mtl_txn_source_types mtst,
                        mfg_lookups ml,
                        mtl_transaction_types mtt
                where mmt.organization_id = orgid
                and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
                and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.cost_group_id = cost_group_id
                and mtst.transaction_source_type_id = mmt.transaction_source_type_id
                and mtt.transaction_type_id = mmt.transaction_type_id
                and ml.lookup_type = 'MTL_TRANSACTION_ACTION'
                and ml.lookup_code = mmt.transaction_action_id + 0
                and mmt.transaction_action_id NOT IN (24,30)
                group by mmt.inventory_item_id,
                        mtst.transaction_source_type_name,
                        mtt.transaction_type_name,
                        ml.meaning;*/

Line: 1140

                /*insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 inventory_item_id,
                 organization_id,
                 transaction_source_type_name,
                 net_qty,
                 net_val,
                 num_txns,
                 abs_qty,
                 abs_val)
                select
                sessionid,
                'ITEM_SRCTYPE_SUMMARY',
                mst.inventory_item_id,
                min(mst.organization_id),
                mst.transaction_source_type_name,
                sum(mst.net_qty),
                sum(mst.net_val),
                sum(mst.num_txns),
                sum(mst.abs_qty),
                sum(mst.abs_val)
                from mtl_summary_temp mst
                where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
                and session_id = sessionid
                group by mst.inventory_item_id, mst.transaction_source_type_name;

Line: 1168

 /*               insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 inventory_item_id,
                 organization_id,
                 transaction_type_name,
                 net_qty,
                 net_val,
                 num_txns,
                 abs_qty,
                 abs_val)
                select
                sessionid,
                'ITEM_TXN_TYPES_SUMMARY',
                mst.inventory_item_id,
                min(mst.organization_id),
                mst.transaction_type_name,
                sum(mst.net_qty),
                sum(mst.net_val),
                sum(mst.num_txns),
                sum(mst.abs_qty),
                sum(mst.abs_val)
                from mtl_summary_temp mst
                where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
                and session_id = sessionid
                group by mst.inventory_item_id, mst.transaction_type_name;

Line: 1196

 /*               insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 inventory_item_id,
                 organization_id,
                 transaction_action_name,
                 net_qty,
                 net_val,
                 num_txns,
                 abs_qty,
                 abs_val)
                select
                sessionid,
                'ITEM_TXN_ACTION_SUMMARY',
                mst.inventory_item_id,
                min(mst.organization_id),
                mst.transaction_action_name,
                sum(mst.net_qty),
                sum(mst.net_val),
                sum(mst.num_txns),
                sum(mst.abs_qty),
                sum(mst.abs_val)
                from mtl_summary_temp mst
                where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
                and session_id = sessionid
                group by mst.inventory_item_id, mst.transaction_action_name;

Line: 1225

		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUBINVENTORY_SUMMARY',
		mmt.subinventory_code,
		cratio*sum(mmt.primary_quantity),
		sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
		from mtl_material_transactions mmt
		where mmt.cost_group_id = cost_group_id
		and mmt.organization_id = orgid
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.transaction_action_id NOT IN (24,30)
		group by mmt.subinventory_code;

Line: 1252

	/*	insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 locator_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUBINVENTORY_LOCATOR_SUMMARY',
		mmt.subinventory_code,
		mmt.locator_id,
		cratio*sum(mmt.primary_quantity),
		sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
		from mtl_material_transactions mmt
		where mmt.cost_group_id = cost_group_id
		and mmt.organization_id = orgid
		and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.transaction_action_id NOT IN (24,30)
		group by mmt.subinventory_code, mmt.locator_id;

Line: 1281

/*		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUBINVENTORY_SUMMARY',
		mst.subinventory,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SUBINVENTORY_LOCATOR_SUMMARY'
		and session_id = sessionid
		group by mst.subinventory;

Line: 1308

/*		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 subinventory,
		 cost_group_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'SUB_COST_GROUP_SUMMARY',
		mmt.subinventory_code,
		mmt.cost_group_id,
		cratio*sum(mmt.primary_quantity),
		sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
		sum(1),
		cratio*sum(abs(mmt.primary_quantity)),
		sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
		from mtl_material_transactions mmt
		where mmt.cost_group_id = cost_group_id
		and mmt.organization_id = orgid
	        and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
		and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.transaction_action_id NOT IN (24,30)
		group by mmt.subinventory_code, mmt.cost_group_id;

Line: 1337

/*		insert into mtl_summary_temp
		(session_id,
		 summary_type,
		 cost_group_id,
		 net_qty,
		 net_val,
		 num_txns,
		 abs_qty,
		 abs_val)
		select
		sessionid,
		'COST_GROUP_SUMMARY',
		mst.cost_group_id,
		sum(mst.net_qty),
		sum(mst.net_val),
		sum(mst.num_txns),
		sum(mst.abs_qty),
		sum(mst.abs_val)
		from mtl_summary_temp mst
		where mst.summary_type = 'SUB_COST_GROUP_SUMMARY'
		and session_id = sessionid
		group by mst.cost_group_id;

Line: 1361

 /*               insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 net_val,
                 num_txns,
                 locator_id)
                select
                sessionid,
                'TOTALS',
                nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),
                nvl(sum(1),0),
                1
                from mtl_material_transactions mmt
                where mmt.organization_id = orgid
                and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
                and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.cost_group_id = cost_group_id
                and mmt.primary_quantity > 0
                and mmt.transaction_action_id NOT IN (24,30);

Line: 1381

                insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 net_val,
                 num_txns,
                 locator_id)*/ /* This is populated for ordering purposes */
               /* select
                sessionid,
                'TOTALS',
                nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),
                nvl(sum(1),0),
                2
                from mtl_material_transactions mmt
                where mmt.organization_id = orgid
                and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
                and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.cost_group_id = cost_group_id
                and mmt.primary_quantity < 0
                and mmt.transaction_action_id NOT IN (24,30);

Line: 1401

                insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 net_val,
                 num_txns,
                 locator_id)*/ /* This is populated for ordering purposes */
               /* select
                sessionid,
                'TOTALS',
                sum(mst.net_val),
                null,
                3
                from mtl_summary_temp mst
                where summary_type = 'ITEM_SUMMARY'
                and session_id = sessionid;

Line: 1432

                delete from mtl_summary_temp where session_id = sessionid;

Line: 1435

                /* We are inserting transaction action as well
                   for later summarization */
 /*               insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 inventory_item_id,
                 organization_id,
                 transaction_source_type_name,
                 transaction_type_name,
                 transaction_action_name,
                 net_qty,
                 net_val,
                 num_txns,
                 abs_qty,
                 abs_val)
                select
                sessionid,
                'ITEM_SRCTYPE_TXNTYPE_SUMMARY',
                mmt.inventory_item_id,
                min(mmt.organization_id),
                mtst.transaction_source_type_name,
                mtt.transaction_type_name,
                ml.meaning,
                sum(mmt.primary_quantity),
                sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),
                sum(1),
                sum(abs(mmt.primary_quantity)),
                sum(nvl(mmt.actual_cost,0)*abs(mmt.primary_quantity))
                from mtl_material_transactions mmt,
                        mtl_txn_source_types mtst,
                        mfg_lookups ml,
                        mtl_transaction_types mtt
                where mmt.organization_id = orgid
                and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
                and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.cost_group_id = cost_group_id
		and mmt.subinventory_code = sub
                and mtt.transaction_type_id = mmt.transaction_type_id
                and ml.lookup_type = 'MTL_TRANSACTION_ACTION'
                and ml.lookup_code = mmt.transaction_action_id + 0
                and mmt.transaction_action_id NOT IN (24,30)
                group by mmt.inventory_item_id,
                        mtst.transaction_source_type_name,
                        mtt.transaction_type_name,
                        ml.meaning;

Line: 1482

 /*               insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 inventory_item_id,
                 organization_id,
                 transaction_source_type_name,
                 net_qty,
                 net_val,
                 num_txns,
                 abs_qty,
                 abs_val)
                select
                sessionid,
                'ITEM_SRCTYPE_SUMMARY',
                mst.inventory_item_id,
                min(mst.organization_id),
                mst.transaction_source_type_name,
                sum(mst.net_qty),
                sum(mst.net_val),
                sum(mst.num_txns),
                sum(mst.abs_qty),
                sum(mst.abs_val)
                from mtl_summary_temp mst
                where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
                and session_id = sessionid
                group by mst.inventory_item_id,
                        mst.transaction_source_type_name;

Line: 1511

 /*               insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 inventory_item_id,
                 organization_id,
                 transaction_type_name,
                 net_qty,
                 net_val,
                 num_txns,
                 abs_qty,
                 abs_val)
                select
                sessionid,
                'ITEM_TXN_TYPES_SUMMARY',
                mst.inventory_item_id,
                min(mst.organization_id),
                mst.transaction_type_name,
                sum(mst.net_qty),
                sum(mst.net_val),
                sum(mst.num_txns),
                sum(mst.abs_qty),
                sum(mst.abs_val)
                from mtl_summary_temp mst
                where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
                and session_id = sessionid
                group by mst.inventory_item_id,
                        mst.transaction_type_name;

Line: 1540

 /*               insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 inventory_item_id,
                 organization_id,
                 transaction_action_name,
                 net_qty,
                 net_val,
                 num_txns,
                 abs_qty,
                 abs_val)
                select
                sessionid,
                'ITEM_TXN_ACTION_SUMMARY',
                mst.inventory_item_id,
                min(mst.organization_id),
                mst.transaction_action_name,
                sum(mst.net_qty),
                sum(mst.net_val),
                sum(mst.num_txns),
                sum(mst.abs_qty),
                sum(mst.abs_val)
                from mtl_summary_temp mst
                where summary_type='ITEM_SRCTYPE_TXNTYPE_SUMMARY'
                and session_id = sessionid
                group by mst.inventory_item_id,
                        mst.transaction_action_name;

Line: 1569

 /*               insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 net_val,
                 num_txns,
                 locator_id)
                select
                sessionid,
                'TOTALS',
                nvl(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity),0),
                nvl(sum(1),0),
                1
                from mtl_material_transactions mmt
                where mmt.organization_id = orgid
                and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
                and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.subinventory_code = sub
                and mmt.cost_group_id = nvl(cost_Group_id, mmt.cost_Group_id)
                and mmt.primary_quantity > 0
                and mmt.transaction_action_id NOT IN (24,30);

Line: 1590

                insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 net_val,
                 num_txns,
                 locator_id)*/ /* This is populated for ordering purposes */
                /*select
                sessionid,
                'TOTALS',
                nvl(abs(sum(nvl(mmt.actual_cost,0)*mmt.primary_quantity)),0),
                nvl(sum(1),0),
                2
                from mtl_material_transactions mmt
                where mmt.organization_id = orgid
                and mmt.transaction_date >= NVL(sdate, mmt.transaction_date - 1)
                and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
                and mmt.subinventory_code = sub
                and mmt.cost_group_id = nvl(cost_group_id, mmt.locator_id)
                and mmt.primary_quantity < 0
                and mmt.transaction_action_id NOT IN (24,30);

Line: 1611

                insert into mtl_summary_temp
                (session_id,
                 summary_type,
                 net_val,
                 num_txns,
                 locator_id)*/ /* This is populated for ordering purposes */
/*                select
                sessionid,
                'TOTALS',
                sum(mst.net_val),
                null,
                3
                from mtl_summary_temp mst
                where summary_type = 'ITEM_SUMMARY'
                and session_id = sessionid;