APPS.INV_TXN_VALIDATIONS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1393: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;

1389:
1390: l_is_revision_control BOOLEAN := FALSE;
1391: l_is_lot_control BOOLEAN := FALSE;
1392: l_is_serial_control BOOLEAN := FALSE;
1393: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
1394: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
1395: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
1396:
1397: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1394: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;

1390: l_is_revision_control BOOLEAN := FALSE;
1391: l_is_lot_control BOOLEAN := FALSE;
1392: l_is_serial_control BOOLEAN := FALSE;
1393: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
1394: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
1395: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
1396:
1397: l_api_version_number CONSTANT NUMBER := 1.0;
1398: l_api_name CONSTANT VARCHAR2(30) := 'Check_Looose_Quantity';

Line 1427: FROM mtl_material_transactions_temp

1423: AND lot_number = p_lot_number;
1424:
1425: CURSOR c_mmtt IS
1426: SELECT cost_group_id,transaction_source_type_id, subinventory_code, locator_id
1427: FROM mtl_material_transactions_temp
1428: WHERE transaction_temp_id = p_transaction_temp_id;
1429:
1430: CURSOR c_item IS
1431: SELECT primary_uom_code

Line 1860: from mtl_material_transactions_temp

1856: EXIT WHEN c_lpn_content%NOTFOUND;
1857:
1858: select count(*)
1859: into l_cnt
1860: from mtl_material_transactions_temp
1861: where allocated_lpn_id = l_lpn_id
1862: and organization_id = p_org_id;
1863:
1864: if l_cnt >=1 then

Line 1929: mtl_material_transactions_temp mmtt

1925: select 1
1926: into l_cnt
1927: from mtl_serial_numbers_temp msnt,
1928: mtl_transaction_lots_temp mtlt,
1929: mtl_material_transactions_temp mmtt
1930: where mmtt.organization_id = p_org_id
1931: and mmtt.inventory_item_id = l_inventory_item_id
1932: and mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1933: and l_serial_number between msnt.fm_serial_number and nvl(msnt.to_serial_number,msnt.fm_serial_number)

Line 1987: mtl_material_transactions_temp mmtt

1983: select 1
1984: into l_cnt
1985: from mtl_serial_numbers_temp msnt,
1986: mtl_transaction_lots_temp mtlt,
1987: mtl_material_transactions_temp mmtt
1988: where mmtt.organization_id = p_org_id
1989: and mmtt.inventory_item_id = p_item_id
1990: and mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1991: and p_serial_number between msnt.fm_serial_number and nvl(msnt.to_serial_number,msnt.fm_serial_number)

Line 3303: from mtl_material_transactions_temp

3299: cursor c_mmtt(p_org_id number,
3300: p_item_id number,
3301: p_rev varchar2) is
3302: select transaction_temp_id, allocated_lpn_id
3303: from mtl_material_transactions_temp
3304: where organization_id = p_org_id
3305: and inventory_item_id = p_item_id
3306: and nvl(revision,'@@@') = nvl(p_rev, nvl(revision,'@@@'));
3307: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 4098: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;

4094: l_is_revision_control BOOLEAN := FALSE;
4095: l_is_lot_control BOOLEAN := FALSE;
4096: l_is_serial_control BOOLEAN := FALSE;
4097:
4098: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
4099: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
4100: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
4101:
4102: l_api_version_number CONSTANT NUMBER := 1.0;

Line 4099: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;

4095: l_is_lot_control BOOLEAN := FALSE;
4096: l_is_serial_control BOOLEAN := FALSE;
4097:
4098: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
4099: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
4100: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
4101:
4102: l_api_version_number CONSTANT NUMBER := 1.0;
4103: l_api_name CONSTANT VARCHAR2(30) := 'Check_Looose_and_packed_Qty';

Line 4131: FROM mtl_material_transactions_temp

4127: AND lot_number = p_lot_number;
4128:
4129: CURSOR c_mmtt IS
4130: SELECT cost_group_id,transaction_source_type_id, subinventory_code, locator_id
4131: FROM mtl_material_transactions_temp
4132: WHERE transaction_temp_id = p_transaction_temp_id;
4133:
4134: CURSOR c_item IS
4135: SELECT primary_uom_code

Line 4559: from mtl_material_transactions_temp mmtt

4555: EXIT WHEN c_lpn_content%NOTFOUND;
4556:
4557: select count(1)
4558: into l_count
4559: from mtl_material_transactions_temp mmtt
4560: where (mmtt.lpn_id = l_lpn_id or mmtt.content_lpn_id = l_lpn_id)
4561: and mmtt.organization_id = p_org_id;
4562:
4563: if l_count > 0 then