APPS.WIP_FLOWUTIL_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1446: from mtl_material_transactions_temp

1442: end_item_unit_number,
1443: transaction_header_id,
1444: completion_transaction_id,
1445: rowid
1446: from mtl_material_transactions_temp
1447: where transaction_temp_id = p_txnTmpID
1448: and transaction_source_type_id = 5
1449: and transaction_source_id is null
1450: and flow_schedule = 'Y'

Line 1534: from mtl_material_transactions_temp

1530: end loop;
1531: else
1532: select count(*)
1533: into l_count
1534: from mtl_material_transactions_temp
1535: where transaction_temp_id = p_txnTmpID;
1536: wip_logger.log('MMTT rowcount is ' || l_count, l_returnStatus);
1537:
1538: for l_paramRec in c_MMTTparams loop

Line 1785: update mtl_material_transactions_temp

1781: end if;
1782:
1783: --if txn originated from MMTT, update the assy record
1784: if(p_txnTmpID is not null) then
1785: update mtl_material_transactions_temp
1786: set last_update_date = sysdate,
1787: last_updated_by = fnd_global.user_id,
1788: last_update_login = fnd_global.login_id,
1789: program_application_id = fnd_global.prog_appl_id,

Line 1883: from mtl_material_transactions_temp

1879: l_cplQty,
1880: l_scrapQty,
1881: l_transactionDate,
1882: l_flowSchedule
1883: from mtl_material_transactions_temp
1884: where transaction_temp_id = p_txnTempID;
1885:
1886: select planned_quantity,
1887: quantity_completed

Line 1955: update mtl_material_transactions_temp

1951: */
1952: procedure setMmttError(p_txnTempID in number,
1953: p_msgData in varchar2) is
1954: begin
1955: update mtl_material_transactions_temp
1956: set last_update_date = sysdate,
1957: last_updated_by = fnd_global.user_id,
1958: last_update_login = fnd_global.login_id,
1959: program_application_id = fnd_global.prog_appl_id,

Line 1970: from mtl_material_transactions_temp

1966: error_explanation = substrb(p_msgData, 1, 240)
1967: where transaction_temp_id = p_txnTempID
1968: or completion_transaction_id =
1969: (select completion_transaction_id
1970: from mtl_material_transactions_temp
1971: where transaction_temp_id = p_txnTempID);
1972: end setMmttError;
1973:
1974:

Line 2392: insert into mtl_material_transactions_temp(

2388: -- derive the txn action and type id
2389: l_childTxnActionID := l_compTbl(l_count).transaction_action_id;
2390: l_childTxnTypeID := getTypeFromAction(l_childTxnActionID);
2391:
2392: insert into mtl_material_transactions_temp(
2393: last_update_date,
2394: last_updated_by,
2395: creation_date,
2396: created_by,

Line 2470: from mtl_material_transactions_temp mmtt

2466: l_compTbl(l_count).supply_locator_id,
2467: l_acctPeriodID,
2468: mmtt.completion_transaction_id,
2469: 'Y'
2470: from mtl_material_transactions_temp mmtt
2471: where mmtt.transaction_temp_id = p_txnTempID;
2472:
2473: if (l_logLevel <= wip_constants.full_logging) then
2474: wip_logger.log(p_msg => 'Insert item ' || l_compTbl(l_count).inventory_item_id ||

Line 2703: from mtl_material_transactions_temp

2699: select inventory_item_id,
2700: subinventory_code,
2701: locator_id,
2702: rowid
2703: from mtl_material_transactions_temp
2704: where completion_transaction_id = cpl_id
2705: and transaction_source_type_id = 5
2706: and flow_schedule = 'Y'
2707: and process_flag = 'Y'

Line 2749: from mtl_material_transactions_temp

2745: l_cplID,
2746: l_wipEntityID,
2747: l_srcProjectID,
2748: l_srcTaskID
2749: from mtl_material_transactions_temp
2750: where transaction_temp_id = p_parentID;
2751:
2752: select nvl(project_reference_enabled, 2),
2753: stock_locator_control_code

Line 2793: update mtl_material_transactions_temp

2789: return;
2790: end if;
2791:
2792: if ( comp_rec.locator_id <> 0 ) then
2793: update mtl_material_transactions_temp
2794: set (locator_id, project_id, task_id) =
2795: (select inventory_location_id,
2796: project_id,
2797: task_id