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 1071: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,

1067: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
1068: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1069:
1070: TYPE rec_mmtt is RECORD (
1071: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1072: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1073: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1074: revision mtl_material_transactions_temp.revision%TYPE,
1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,

Line 1072: organization_id mtl_material_transactions_temp.organization_id%TYPE,

1068: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1069:
1070: TYPE rec_mmtt is RECORD (
1071: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1072: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1073: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1074: revision mtl_material_transactions_temp.revision%TYPE,
1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,

Line 1073: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,

1069:
1070: TYPE rec_mmtt is RECORD (
1071: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1072: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1073: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1074: revision mtl_material_transactions_temp.revision%TYPE,
1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,

Line 1074: revision mtl_material_transactions_temp.revision%TYPE,

1070: TYPE rec_mmtt is RECORD (
1071: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1072: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1073: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1074: revision mtl_material_transactions_temp.revision%TYPE,
1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,

Line 1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,

1071: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1072: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1073: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1074: revision mtl_material_transactions_temp.revision%TYPE,
1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1079: project_id mtl_material_transactions_temp.project_id%TYPE,

Line 1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,

1072: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1073: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1074: revision mtl_material_transactions_temp.revision%TYPE,
1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1079: project_id mtl_material_transactions_temp.project_id%TYPE,
1080: task_id mtl_material_transactions_temp.task_id%type,

Line 1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,

1073: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1074: revision mtl_material_transactions_temp.revision%TYPE,
1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1079: project_id mtl_material_transactions_temp.project_id%TYPE,
1080: task_id mtl_material_transactions_temp.task_id%type,
1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,

Line 1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,

1074: revision mtl_material_transactions_temp.revision%TYPE,
1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1079: project_id mtl_material_transactions_temp.project_id%TYPE,
1080: task_id mtl_material_transactions_temp.task_id%type,
1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,

Line 1079: project_id mtl_material_transactions_temp.project_id%TYPE,

1075: from_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1079: project_id mtl_material_transactions_temp.project_id%TYPE,
1080: task_id mtl_material_transactions_temp.task_id%type,
1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,

Line 1080: task_id mtl_material_transactions_temp.task_id%type,

1076: to_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1079: project_id mtl_material_transactions_temp.project_id%TYPE,
1080: task_id mtl_material_transactions_temp.task_id%type,
1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1084: reference mtl_material_transactions_temp.transaction_reference%TYPE,

Line 1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,

1077: uom_code mtl_material_transactions_temp.transaction_uom%TYPE,
1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1079: project_id mtl_material_transactions_temp.project_id%TYPE,
1080: task_id mtl_material_transactions_temp.task_id%type,
1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1084: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1085: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,

Line 1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,

1078: reason_id mtl_material_transactions_temp.reason_id%TYPE,
1079: project_id mtl_material_transactions_temp.project_id%TYPE,
1080: task_id mtl_material_transactions_temp.task_id%type,
1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1084: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1085: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1086: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,

Line 1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,

1079: project_id mtl_material_transactions_temp.project_id%TYPE,
1080: task_id mtl_material_transactions_temp.task_id%type,
1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1084: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1085: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1086: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1087: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE

Line 1084: reference mtl_material_transactions_temp.transaction_reference%TYPE,

1080: task_id mtl_material_transactions_temp.task_id%type,
1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1084: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1085: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1086: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1087: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE
1088: );

Line 1085: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,

1081: transaction_type_id mtl_material_transactions_temp.transaction_type_id%TYPE,
1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1084: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1085: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1086: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1087: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE
1088: );
1089:

Line 1086: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,

1082: transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE,
1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1084: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1085: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1086: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1087: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE
1088: );
1089:
1090: l_rec_mtrl rec_mmtt;

Line 1087: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE

1083: to_organization_id mtl_material_transactions_temp.organization_id%TYPE,
1084: reference mtl_material_transactions_temp.transaction_reference%TYPE,
1085: reference_id mtl_material_transactions_temp.rcv_transaction_id%TYPE,
1086: transaction_action_id mtl_material_transactions_temp.transaction_action_id%TYPE,
1087: last_updated_by mtl_material_transactions_temp.last_updated_by%TYPE
1088: );
1089:
1090: l_rec_mtrl rec_mmtt;
1091:

Line 1188: from mtl_material_transactions_temp mmtt

1184: mmtt.transaction_reference,
1185: decode(mmtt.source_code,'RCV', mmtt.rcv_transaction_id,to_number(NULL)),
1186: mmtt.transaction_action_id,
1187: mmtt.last_updated_by
1188: from mtl_material_transactions_temp mmtt
1189: where mmtt.transaction_temp_id = p_transaction_temp_id;
1190:
1191: begin
1192: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1696: FROM mtl_material_Transactions_temp

1692:
1693: BEGIN
1694: SELECT nvl(trx_source_line_id, -999)
1695: INTO l_trx_source_line_id
1696: FROM mtl_material_Transactions_temp
1697: WHERE transaction_temp_id = p_transaction_temp_id
1698: AND transaction_source_type_id = INV_GLOBALS.G_SOURCETYPE_RMA
1699: AND transaction_action_id = INV_GLOBALS.G_ACTION_RECEIPT;
1700: