APPS.WIP_FLOWUTIL_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1415: from mtl_material_transactions_temp

1411: end_item_unit_number,
1412: transaction_header_id,
1413: completion_transaction_id,
1414: rowid
1415: from mtl_material_transactions_temp
1416: where transaction_temp_id = p_txnTmpID
1417: and transaction_source_type_id = 5
1418: and transaction_source_id is null
1419: and flow_schedule = 'Y'

Line 1503: from mtl_material_transactions_temp

1499: end loop;
1500: else
1501: select count(*)
1502: into l_count
1503: from mtl_material_transactions_temp
1504: where transaction_temp_id = p_txnTmpID;
1505: wip_logger.log('MMTT rowcount is ' || l_count, l_returnStatus);
1506:
1507: for l_paramRec in c_MMTTparams loop

Line 1754: update mtl_material_transactions_temp

1750: end if;
1751:
1752: --if txn originated from MMTT, update the assy record
1753: if(p_txnTmpID is not null) then
1754: update mtl_material_transactions_temp
1755: set last_update_date = sysdate,
1756: last_updated_by = fnd_global.user_id,
1757: last_update_login = fnd_global.login_id,
1758: program_application_id = fnd_global.prog_appl_id,

Line 1852: from mtl_material_transactions_temp

1848: l_cplQty,
1849: l_scrapQty,
1850: l_transactionDate,
1851: l_flowSchedule
1852: from mtl_material_transactions_temp
1853: where transaction_temp_id = p_txnTempID;
1854:
1855: select planned_quantity,
1856: quantity_completed

Line 1922: update mtl_material_transactions_temp

1918: */
1919: procedure setMmttError(p_txnTempID in number,
1920: p_msgData in varchar2) is
1921: begin
1922: update mtl_material_transactions_temp
1923: set last_update_date = sysdate,
1924: last_updated_by = fnd_global.user_id,
1925: last_update_login = fnd_global.login_id,
1926: program_application_id = fnd_global.prog_appl_id,

Line 1937: from mtl_material_transactions_temp

1933: error_explanation = substrb(p_msgData, 1, 240)
1934: where transaction_temp_id = p_txnTempID
1935: or completion_transaction_id =
1936: (select completion_transaction_id
1937: from mtl_material_transactions_temp
1938: where transaction_temp_id = p_txnTempID);
1939: end setMmttError;
1940:
1941:

Line 2353: insert into mtl_material_transactions_temp(

2349: -- derive the txn action and type id
2350: l_childTxnActionID := l_compTbl(l_count).transaction_action_id;
2351: l_childTxnTypeID := getTypeFromAction(l_childTxnActionID);
2352:
2353: insert into mtl_material_transactions_temp(
2354: last_update_date,
2355: last_updated_by,
2356: creation_date,
2357: created_by,

Line 2431: from mtl_material_transactions_temp mmtt

2427: l_compTbl(l_count).supply_locator_id,
2428: l_acctPeriodID,
2429: mmtt.completion_transaction_id,
2430: 'Y'
2431: from mtl_material_transactions_temp mmtt
2432: where mmtt.transaction_temp_id = p_txnTempID;
2433:
2434: if (l_logLevel <= wip_constants.full_logging) then
2435: wip_logger.log(p_msg => 'Insert item ' || l_compTbl(l_count).inventory_item_id ||

Line 2664: from mtl_material_transactions_temp

2660: select inventory_item_id,
2661: subinventory_code,
2662: locator_id,
2663: rowid
2664: from mtl_material_transactions_temp
2665: where completion_transaction_id = cpl_id
2666: and transaction_source_type_id = 5
2667: and flow_schedule = 'Y'
2668: and process_flag = 'Y'

Line 2710: from mtl_material_transactions_temp

2706: l_cplID,
2707: l_wipEntityID,
2708: l_srcProjectID,
2709: l_srcTaskID
2710: from mtl_material_transactions_temp
2711: where transaction_temp_id = p_parentID;
2712:
2713: select nvl(project_reference_enabled, 2),
2714: stock_locator_control_code

Line 2754: update mtl_material_transactions_temp

2750: return;
2751: end if;
2752:
2753: if ( comp_rec.locator_id <> 0 ) then
2754: update mtl_material_transactions_temp
2755: set (locator_id, project_id, task_id) =
2756: (select inventory_location_id,
2757: project_id,
2758: task_id