APPS.INV_TXN_VALIDATIONS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1546: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;

1542:
1543: l_is_revision_control BOOLEAN := FALSE;
1544: l_is_lot_control BOOLEAN := FALSE;
1545: l_is_serial_control BOOLEAN := FALSE;
1546: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
1547: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
1548: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
1549:
1550: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1547: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;

1543: l_is_revision_control BOOLEAN := FALSE;
1544: l_is_lot_control BOOLEAN := FALSE;
1545: l_is_serial_control BOOLEAN := FALSE;
1546: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
1547: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
1548: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
1549:
1550: l_api_version_number CONSTANT NUMBER := 1.0;
1551: l_api_name CONSTANT VARCHAR2(30) := 'Check_Looose_Quantity';

Line 1580: FROM mtl_material_transactions_temp

1576: AND lot_number = p_lot_number;
1577:
1578: CURSOR c_mmtt IS
1579: SELECT cost_group_id,transaction_source_type_id, subinventory_code, locator_id
1580: FROM mtl_material_transactions_temp
1581: WHERE transaction_temp_id = p_transaction_temp_id;
1582:
1583: CURSOR c_item IS
1584: SELECT primary_uom_code

Line 2013: from mtl_material_transactions_temp

2009: EXIT WHEN c_lpn_content%NOTFOUND;
2010:
2011: select count(*)
2012: into l_cnt
2013: from mtl_material_transactions_temp
2014: where allocated_lpn_id = l_lpn_id
2015: and organization_id = p_org_id;
2016:
2017: if l_cnt >=1 then

Line 2082: mtl_material_transactions_temp mmtt

2078: select 1
2079: into l_cnt
2080: from mtl_serial_numbers_temp msnt,
2081: mtl_transaction_lots_temp mtlt,
2082: mtl_material_transactions_temp mmtt
2083: where mmtt.organization_id = p_org_id
2084: and mmtt.inventory_item_id = l_inventory_item_id
2085: and mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
2086: and l_serial_number between msnt.fm_serial_number and nvl(msnt.to_serial_number,msnt.fm_serial_number)

Line 2154: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt

2150: EXIT WHEN c_lpn_content%NOTFOUND;
2151:
2152: select count(*)
2153: into l_cnt
2154: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
2155: where mmtt.lpn_id = l_lpn_id
2156: and mmtt.transaction_temp_id = wdt.transaction_temp_id
2157: and wdt.status=4 -- Loaded task
2158: and mmtt.organization_id = p_org_id;

Line 2213: mtl_material_transactions_temp mmtt

2209: select 1
2210: into l_cnt
2211: from mtl_serial_numbers_temp msnt,
2212: mtl_transaction_lots_temp mtlt,
2213: mtl_material_transactions_temp mmtt
2214: where mmtt.organization_id = p_org_id
2215: and mmtt.inventory_item_id = p_item_id
2216: and mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
2217: and p_serial_number between msnt.fm_serial_number and nvl(msnt.to_serial_number,msnt.fm_serial_number)

Line 3582: from mtl_material_transactions_temp

3578: cursor c_mmtt(p_org_id number,
3579: p_item_id number,
3580: p_rev varchar2) is
3581: select transaction_temp_id, allocated_lpn_id
3582: from mtl_material_transactions_temp
3583: where organization_id = p_org_id
3584: and inventory_item_id = p_item_id
3585: and nvl(revision,'@@@') = nvl(p_rev, nvl(revision,'@@@'));
3586: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 4377: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;

4373: l_is_revision_control BOOLEAN := FALSE;
4374: l_is_lot_control BOOLEAN := FALSE;
4375: l_is_serial_control BOOLEAN := FALSE;
4376:
4377: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
4378: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
4379: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
4380:
4381: l_api_version_number CONSTANT NUMBER := 1.0;

Line 4378: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;

4374: l_is_lot_control BOOLEAN := FALSE;
4375: l_is_serial_control BOOLEAN := FALSE;
4376:
4377: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
4378: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
4379: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
4380:
4381: l_api_version_number CONSTANT NUMBER := 1.0;
4382: l_api_name CONSTANT VARCHAR2(30) := 'Check_Looose_and_packed_Qty';

Line 4410: FROM mtl_material_transactions_temp

4406: AND lot_number = p_lot_number;
4407:
4408: CURSOR c_mmtt IS
4409: SELECT cost_group_id,transaction_source_type_id, subinventory_code, locator_id
4410: FROM mtl_material_transactions_temp
4411: WHERE transaction_temp_id = p_transaction_temp_id;
4412:
4413: CURSOR c_item IS
4414: SELECT primary_uom_code

Line 4838: from mtl_material_transactions_temp mmtt

4834: EXIT WHEN c_lpn_content%NOTFOUND;
4835:
4836: select count(1)
4837: into l_count
4838: from mtl_material_transactions_temp mmtt
4839: where (mmtt.lpn_id = l_lpn_id or mmtt.content_lpn_id = l_lpn_id)
4840: and mmtt.organization_id = p_org_id;
4841:
4842: if l_count > 0 then