eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_RULES_WORKBENCH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1267: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,

1263: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
1264: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1265:
1266: TYPE rec_mmtt is RECORD (
1267: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1268: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1269: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1270: revision mtl_material_transactions_temp.revision%TYPE,
1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,

Line 1268: organization_id mtl_material_transactions_temp.organization_id%TYPE,

1264: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1265:
1266: TYPE rec_mmtt is RECORD (
1267: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1268: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1269: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1270: revision mtl_material_transactions_temp.revision%TYPE,
1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,

Line 1269: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,

1265:
1266: TYPE rec_mmtt is RECORD (
1267: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1268: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1269: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1270: revision mtl_material_transactions_temp.revision%TYPE,
1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,

Line 1270: revision mtl_material_transactions_temp.revision%TYPE,

1266: TYPE rec_mmtt is RECORD (
1267: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1268: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1269: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1270: revision mtl_material_transactions_temp.revision%TYPE,
1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,

Line 1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,

1267: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1268: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1269: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1270: revision mtl_material_transactions_temp.revision%TYPE,
1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1275: project_id mtl_material_transactions_temp.project_id%TYPE,

Line 1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,

1268: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1269: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1270: revision mtl_material_transactions_temp.revision%TYPE,
1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1275: project_id mtl_material_transactions_temp.project_id%TYPE,
1276: task_id mtl_material_transactions_temp.task_id%type,

Line 1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,

1269: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1270: revision mtl_material_transactions_temp.revision%TYPE,
1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1275: project_id mtl_material_transactions_temp.project_id%TYPE,
1276: task_id mtl_material_transactions_temp.task_id%type,
1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,

Line 1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,

1270: revision mtl_material_transactions_temp.revision%TYPE,
1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1275: project_id mtl_material_transactions_temp.project_id%TYPE,
1276: task_id mtl_material_transactions_temp.task_id%type,
1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,

Line 1275: project_id mtl_material_transactions_temp.project_id%TYPE,

1271: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1275: project_id mtl_material_transactions_temp.project_id%TYPE,
1276: task_id mtl_material_transactions_temp.task_id%type,
1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,

Line 1276: task_id mtl_material_transactions_temp.task_id%type,

1272: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1275: project_id mtl_material_transactions_temp.project_id%TYPE,
1276: task_id mtl_material_transactions_temp.task_id%type,
1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1280: reference mtl_material_transactions_temp.transaction_reference%TYPE,

Line 1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,

1273: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1275: project_id mtl_material_transactions_temp.project_id%TYPE,
1276: task_id mtl_material_transactions_temp.task_id%type,
1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1280: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1281: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,

Line 1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,

1274: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1275: project_id mtl_material_transactions_temp.project_id%TYPE,
1276: task_id mtl_material_transactions_temp.task_id%type,
1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1280: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1281: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1282: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,

Line 1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,

1275: project_id mtl_material_transactions_temp.project_id%TYPE,
1276: task_id mtl_material_transactions_temp.task_id%type,
1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1280: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1281: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1282: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1283: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE

Line 1280: reference mtl_material_transactions_temp.transaction_reference%TYPE,

1276: task_id mtl_material_transactions_temp.task_id%type,
1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1280: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1281: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1282: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1283: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE
1284: );

Line 1281: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,

1277: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1280: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1281: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1282: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1283: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE
1284: );
1285:

Line 1282: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,

1278: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1280: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1281: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1282: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1283: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE
1284: );
1285:
1286: l_rec_mtrl rec_mmtt;

Line 1283: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE

1279: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1280: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1281: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1282: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1283: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE
1284: );
1285:
1286: l_rec_mtrl rec_mmtt;
1287:

Line 1384: from mtl_material_transactions_temp mmtt

1380: mmtt.transaction_reference,
1381: decode(mmtt.source_code,'RCV', mmtt.rcv_transaction_id,to_number(NULL)),
1382: mmtt.transaction_action_id,
1383: mmtt.last_updated_by
1384: from mtl_material_transactions_temp mmtt
1385: where mmtt.transaction_temp_id = p_transaction_temp_id;
1386:
1387: begin
1388: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1995: FROM mtl_material_Transactions_temp

1991:
1992: BEGIN
1993: SELECT nvl(trx_source_line_id, -999)
1994: INTO l_trx_source_line_id
1995: FROM mtl_material_Transactions_temp
1996: WHERE transaction_temp_id = p_transaction_temp_id
1997: AND transaction_source_type_id = INV_GLOBALS.G_SOURCETYPE_RMA
1998: AND transaction_action_id = INV_GLOBALS.G_ACTION_RECEIPT;
1999: