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.INV_TXN_MANAGER_GRP dependencies on MTL_TRANSACTIONS_INTERFACE

Line 436: FROM MTL_TRANSACTIONS_INTERFACE MTI,

432: mti.transaction_batch_id,
433: mti.transaction_batch_seq,
434: mti.kanban_card_id,
435: mti.transaction_mode --J-dev
436: FROM MTL_TRANSACTIONS_INTERFACE MTI,
437: MTL_TRANSACTION_LOTS_INTERFACE MTLI,
438: MTL_SYSTEM_ITEMS_B MSI
439: WHERE mti.transaction_interface_id = p_interface_id
440: AND MTI.transaction_interface_id = mtli.transaction_interface_id

Line 454: FROM mtl_transactions_interface

450: BEGIN
451:
452: SELECT count(parent_id)
453: INTO l_count
454: FROM mtl_transactions_interface
455: WHERE parent_id = p_parent_id;
456:
457: SELECT abs(primary_quantity)
458: INTO l_split_qty

Line 459: FROM mtl_transactions_interface

455: WHERE parent_id = p_parent_id;
456:
457: SELECT abs(primary_quantity)
458: INTO l_split_qty
459: FROM mtl_transactions_interface
460: WHERE transaction_interface_id = p_parent_id;
461:
462: SELECT sum(abs(primary_quantity))
463: INTO l_partial_total_qty

Line 464: FROM mtl_transactions_interface

460: WHERE transaction_interface_id = p_parent_id;
461:
462: SELECT sum(abs(primary_quantity))
463: INTO l_partial_total_qty
464: FROM mtl_transactions_interface
465: WHERE parent_id = p_parent_id
466: AND transaction_interface_id <> p_parent_id;
467:
468: l_remaining_qty := l_split_qty - l_partial_total_qty;

Line 479: INSERT INTO mtl_transactions_interface

475: IF (l_debug = 1) THEN
476: inv_log_util.trace('insert into mmti is ' || l_mti_csr.transaction_interface_id, 'INV_TXN_MANAGER_GRP', 9);
477: END IF;
478:
479: INSERT INTO mtl_transactions_interface
480: ( transaction_header_id ,
481: transaction_interface_id ,
482: transaction_mode ,
483: lock_flag ,

Line 916: FROM MTL_TRANSACTIONS_INTERFACE

912: tmp_seg_arr(22).colvalue, tmp_seg_arr(23).colvalue, tmp_seg_arr(24).colvalue,
913: tmp_seg_arr(25).colvalue, tmp_seg_arr(26).colvalue, tmp_seg_arr(27).colvalue,
914: tmp_seg_arr(28).colvalue, tmp_seg_arr(29).colvalue, tmp_seg_arr(30).colvalue,
915: l_trxdate/*Bug#5176266*/
916: FROM MTL_TRANSACTIONS_INTERFACE
917: WHERE ROWID = p_rowid;
918:
919: l_popul := FALSE;
920: i := 0;

Line 1081: FROM mtl_transactions_interface mti

1077: l_segs1(17),
1078: l_segs1(18),
1079: l_segs1(19),
1080: l_segs1(20)
1081: FROM mtl_transactions_interface mti
1082: WHERE mti.rowid = p_rowid;
1083:
1084: -- find flex field type
1085: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MSTK');

Line 1180: FROM MTL_TRANSACTIONS_INTERFACE

1176: tmp_seg_arr(19).colvalue, tmp_seg_arr(20).colvalue, tmp_seg_arr(21).colvalue,
1177: tmp_seg_arr(22).colvalue, tmp_seg_arr(23).colvalue, tmp_seg_arr(24).colvalue,
1178: tmp_seg_arr(25).colvalue, tmp_seg_arr(26).colvalue, tmp_seg_arr(27).colvalue,
1179: tmp_seg_arr(28).colvalue, tmp_seg_arr(29).colvalue, tmp_seg_arr(30).colvalue
1180: FROM MTL_TRANSACTIONS_INTERFACE
1181: WHERE ROWID = p_rowid;
1182:
1183: SELECT CHART_OF_ACCOUNTS_ID
1184: INTO l_chart

Line 1322: UPDATE MTL_TRANSACTIONS_INTERFACE

1318: ERROR_CODE = substrb(l_error_code,1,240)
1319: WHERE ROWID = lot_rowid;
1320: END IF;
1321: IF (p_rowid IS NOT NULL) THEN
1322: UPDATE MTL_TRANSACTIONS_INTERFACE
1323: SET ERROR_CODE = substrb(l_error_code,1,240),
1324: ERROR_EXPLANATION = substrb(l_error_exp,1,240),
1325: LAST_UPDATE_DATE = sysdate,
1326: LAST_UPDATED_BY = l_userid,

Line 1361: FROM MTL_TRANSACTIONS_INTERFACE

1357: transaction_source_type_id,
1358: transaction_source_id,
1359: transaction_date, --Bug#5176266.
1360: rowid
1361: FROM MTL_TRANSACTIONS_INTERFACE
1362: WHERE transaction_header_id = p_header_id
1363: AND process_flag = 1
1364: AND (inventory_item_id is NULL OR distribution_account_id is NULL
1365: OR

Line 1368: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;

1364: AND (inventory_item_id is NULL OR distribution_account_id is NULL
1365: OR
1366: (transaction_source_id is NULL AND transaction_source_type_id in (2,3,6,8))); --Bug 2971400
1367:
1368: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1369: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1370: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1371: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1372: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.

Line 1369: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;

1365: OR
1366: (transaction_source_id is NULL AND transaction_source_type_id in (2,3,6,8))); --Bug 2971400
1367:
1368: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1369: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1370: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1371: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1372: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.
1373: BEGIN

Line 1370: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;

1366: (transaction_source_id is NULL AND transaction_source_type_id in (2,3,6,8))); --Bug 2971400
1367:
1368: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1369: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1370: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1371: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1372: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.
1373: BEGIN
1374:

Line 1371: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;

1367:
1368: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1369: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1370: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1371: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1372: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.
1373: BEGIN
1374:
1375: FOR c_mti_row in c_mti LOOP

Line 1372: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.

1368: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1369: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1370: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1371: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1372: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.
1373: BEGIN
1374:
1375: FOR c_mti_row in c_mti LOOP
1376: l_acctid := c_mti_row.distribution_account_id;

Line 1460: UPDATE MTL_TRANSACTIONS_INTERFACE

1456: END IF;
1457:
1458: END IF; */
1459:
1460: UPDATE MTL_TRANSACTIONS_INTERFACE
1461: SET inventory_item_id = l_itemid,
1462: distribution_account_id = l_acctid,
1463: transaction_source_id = l_trxsrc
1464: WHERE rowid = c_mti_row.rowid;

Line 1546: FROM gme_transaction_pairs gtp, MTL_TRANSACTIONS_INTERFACE mti

1542: AND inventory_item_id = item_id;
1543:
1544: CURSOR check_gme_reversal IS
1545: SELECT count(1)
1546: FROM gme_transaction_pairs gtp, MTL_TRANSACTIONS_INTERFACE mti
1547: WHERE mti.rowid = p_rowid
1548: AND gtp.batch_id = mti.transaction_source_id
1549: AND gtp.material_detail_id = mti.trx_source_line_id
1550: AND transaction_id1 = mti.source_line_id

Line 1568: mtl_transactions_interface mti, mtl_transaction_lots_interface mtli

1564: l_is_yield_correction NUMBER := 0;
1565: CURSOR check_yield_correction IS
1566: SELECT 1
1567: FROM mtl_material_transactions mmt,mtl_transaction_lot_numbers mtln,
1568: mtl_transactions_interface mti, mtl_transaction_lots_interface mtli
1569: WHERE mti.ROWID = p_rowid
1570: AND mtli.ROWID = p_lot_rowid
1571: AND mmt.transaction_id = mti.transaction_sequence_id
1572: AND mmt.transaction_id = mtln.transaction_id

Line 1931: FROM MTL_TRANSACTIONS_INTERFACE

1927: TRANSACTION_QUANTITY,
1928: TRANSACTION_UOM,
1929: SECONDARY_TRANSACTION_QUANTITY,
1930: SECONDARY_UOM_CODE
1931: FROM MTL_TRANSACTIONS_INTERFACE
1932: WHERE TRANSACTION_HEADER_ID = p_header_id
1933: AND PROCESS_FLAG = 1
1934: ORDER BY ORGANIZATION_ID,INVENTORY_ITEM_ID,REVISION,
1935: SUBINVENTORY_CODE,LOCATOR_ID;

Line 1980: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

1976: | Derive transaction_action_id and transaction_source_
1977: | type_id
1978: +---------------------------------------------------------*/
1979:
1980: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
1981: SET LAST_UPDATE_DATE = SYSDATE,
1982: LAST_UPDATED_BY = p_userid,
1983: LAST_UPDATE_LOGIN = p_loginid,
1984: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2006: UPDATE mtl_transactions_interface mti

2002: +-----------------------------------------------------------------+*/
2003:
2004: loaderrmsg('INV_TXN_NOT_SUPPORTED_CODE', 'INV_TXN_NOT_SUPPORTED_CODE_EXP');
2005:
2006: UPDATE mtl_transactions_interface mti
2007: SET last_update_date = SYSDATE,
2008: last_updated_by = p_userid,
2009: last_update_login = p_loginid,
2010: program_update_date = SYSDATE,

Line 2037: FROM MTL_TRANSACTIONS_INTERFACE

2033: SELECT TRANSACTION_SOURCE_TYPE_ID,
2034: DECODE(UPPER(NVL(FLOW_SCHEDULE,'N')), 'Y',1,0),
2035: NVL(SCHEDULED_FLAG,0)
2036: INTO srctypeid, tvu_flow_schedule, tev_scheduled_flag
2037: FROM MTL_TRANSACTIONS_INTERFACE
2038: WHERE TRANSACTION_HEADER_ID = p_header_id
2039: AND PROCESS_FLAG = 1
2040: AND ROWNUM < 2;
2041: EXCEPTION

Line 2075: FROM MTL_TRANSACTIONS_INTERFACE

2071: BEGIN
2072: SELECT
2073: DECODE(UPPER(NVL(FLOW_SCHEDULE,'N')), 'Y',1,0)
2074: INTO flow_schedule_children
2075: FROM MTL_TRANSACTIONS_INTERFACE
2076: WHERE TRANSACTION_HEADER_ID = p_header_id
2077: AND TRANSACTION_ACTION_ID IN (1, 27, 33, 34)
2078: AND PROCESS_FLAG = 1
2079: AND ROWNUM < 2;

Line 2110: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2106: -- that are populated directly to the interface table
2107: --------------------------------------------------------
2108:
2109: --J-dev for Drop Ship
2110: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2111: SET LAST_UPDATE_DATE = SYSDATE,
2112: LAST_UPDATED_BY = p_userid,
2113: LAST_UPDATE_LOGIN = p_loginid,
2114: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2158: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2154: -- but are still inserted into MTI. We should not validate them
2155: -- but will have to move them to MMTT and it will be deleted from the
2156: -- table before pushed to MMT. So, if the source type is 5 (WIP) and
2157: -- wip_supply_type is 6, we do not validate them
2158: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2159: SET LAST_UPDATE_DATE = SYSDATE,
2160: LAST_UPDATED_BY = p_userid,
2161: LAST_UPDATE_LOGIN = p_loginid,
2162: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2191: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2187: +----------------------------------------------------*/
2188: loaderrmsg('INV_INT_ITMCODE','INV_INT_ITMEXP');
2189:
2190:
2191: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2192: SET LAST_UPDATE_DATE = SYSDATE,
2193: LAST_UPDATED_BY = p_userid,
2194: LAST_UPDATE_LOGIN = p_loginid,
2195: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2224: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2220: | The items are validated seperately for average cost update
2221: | transactions as done in the form
2222: +----------------------------------------------------------------*/
2223:
2224: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2225: SET LAST_UPDATE_DATE = SYSDATE,
2226: LAST_UPDATED_BY = p_userid,
2227: LAST_UPDATE_LOGIN = p_loginid,
2228: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2257: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2253: +----------------------------------------------------------------*/
2254:
2255: IF (l_validate_full) THEN--J-dev
2256: loaderrmsg('INV_POS_QTY_LAYER','INV_POS_QTY_LAYER');
2257: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2258: SET LAST_UPDATE_DATE = SYSDATE,
2259: LAST_UPDATED_BY = p_userid,
2260: LAST_UPDATE_LOGIN = p_loginid,
2261: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2289: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2285:
2286: IF (l_validate_full) THEN--J-dev
2287: loaderrmsg('INV_INT_ITMCTRL','INV_INT_ITMECTRL');
2288:
2289: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2290: SET LAST_UPDATE_DATE = SYSDATE,
2291: LAST_UPDATED_BY = p_userid,
2292: LAST_UPDATE_LOGIN = p_loginid,
2293: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2324: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2320:
2321: /**Bug 13365231 we need allow serial contorl 'sale order receipt' at source org
2322: * when the transaction is Int Order Direct Ship
2323: */
2324: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2325: SET LAST_UPDATE_DATE = SYSDATE,
2326: LAST_UPDATED_BY = p_userid,
2327: LAST_UPDATE_LOGIN = p_loginid,
2328: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2367: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2363:
2364: IF (l_validate_full) THEN --J-dev
2365: loaderrmsg('INV_INT_ITEMCODE','INV_INT_XFRITMEXP');
2366:
2367: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2368: SET LAST_UPDATE_DATE = SYSDATE,
2369: LAST_UPDATED_BY = p_userid,
2370: LAST_UPDATE_LOGIN = p_loginid,
2371: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2401: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2397: +-----------------------------------------------*/
2398: loaderrmsg('INV_INT_SUBCODE','INV_INT_SUBEXP');
2399:
2400:
2401: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2402: SET LAST_UPDATE_DATE = SYSDATE,
2403: LAST_UPDATED_BY = p_userid,
2404: LAST_UPDATE_LOGIN = p_loginid,
2405: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2445: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2441:
2442: loaderrmsg('INV_INT_XSUBCODE','INV_INT_XSUBEXP');
2443:
2444:
2445: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2446: SET LAST_UPDATE_DATE = SYSDATE,
2447: LAST_UPDATED_BY = p_userid,
2448: LAST_UPDATE_LOGIN = p_loginid,
2449: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2494: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2490: | Validating restricted subinventories
2491: +-----------------------------------------------------------*/
2492: loaderrmsg('INV_INT_SUBCODE','INV_INT_RESUBEXP');
2493:
2494: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2495: SET LAST_UPDATE_DATE = SYSDATE,
2496: LAST_UPDATED_BY = p_userid,
2497: LAST_UPDATE_LOGIN = p_loginid,
2498: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2541: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2537:
2538: loaderrmsg('INV_INT_XSUBCODE','INV_INT_RESXFRSUBEXP');
2539:
2540:
2541: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2542: SET LAST_UPDATE_DATE = SYSDATE,
2543: LAST_UPDATED_BY = p_userid,
2544: LAST_UPDATE_LOGIN = p_loginid,
2545: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2616: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2612: IF exp_to_ast_allowed = 1 THEN
2613:
2614: loaderrmsg('INV_INT_SUBCODE','INV_INT_SUBTYPEXP');
2615:
2616: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2617: SET LAST_UPDATE_DATE = SYSDATE,
2618: LAST_UPDATED_BY = p_userid,
2619: LAST_UPDATE_LOGIN = p_loginid,
2620: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2660: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2656:
2657: l_count := SQL%ROWCOUNT;
2658:
2659:
2660: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2661: SET LAST_UPDATE_DATE = SYSDATE,
2662: LAST_UPDATED_BY = p_userid,
2663: LAST_UPDATE_LOGIN = p_loginid,
2664: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2695: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2691: AND MSI.ASSET_INVENTORY = 1);
2692:
2693: l_count := l_count + SQL%ROWCOUNT;
2694:
2695: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2696: SET LAST_UPDATE_DATE = SYSDATE,
2697: LAST_UPDATED_BY = p_userid,
2698: LAST_UPDATE_LOGIN = p_loginid,
2699: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2732: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2728: ELSE
2729:
2730: loaderrmsg('INV_INT_SUBCODE','INV_INT_SUBTYPEXP');
2731:
2732: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2733: SET LAST_UPDATE_DATE = SYSDATE,
2734: LAST_UPDATED_BY = p_userid,
2735: LAST_UPDATE_LOGIN = p_loginid,
2736: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2780: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2776:
2777: loaderrmsg('INV_INT_SRCCODE','INV_INT_SALEXP');
2778:
2779:
2780: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2781: SET LAST_UPDATE_DATE = SYSDATE,
2782: LAST_UPDATED_BY = p_userid,
2783: LAST_UPDATE_LOGIN = p_loginid,
2784: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2806: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2802:
2803: /*Bug#5176266. Made changes to the below UPDATE statement
2804: to validate the Account effective date against transactions
2805: date( not sysdate)*/
2806: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2807: SET LAST_UPDATE_DATE = SYSDATE,
2808: LAST_UPDATED_BY = p_userid,
2809: LAST_UPDATE_LOGIN = p_loginid,
2810: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2836: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2832: /* Bug# 3249130/ 3249131, Port change of Bug# 3238160. Changing the DML statement that populates the
2833: error code in MTI when the Account alias is inactive. The query now checks for the
2834: EFFECTIVE_DATE and DISABLE_DATE rather than START_DATE_ACTIVE and END_DATE_ACTIVE*/
2835:
2836: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2837: SET LAST_UPDATE_DATE = SYSDATE,
2838: LAST_UPDATED_BY = p_userid,
2839: LAST_UPDATE_LOGIN = p_loginid,
2840: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2872: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2868: | Validating transaction type
2869: +----------------------------------------------------*/
2870: loaderrmsg('INV_INT_TRXTYPCODE','INV_INT_TYPEXP');
2871:
2872: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2873: SET LAST_UPDATE_DATE = SYSDATE,
2874: LAST_UPDATED_BY = p_userid,
2875: LAST_UPDATE_LOGIN = p_loginid,
2876: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2900: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2896: | Validating transaction actions
2897: +-------------------------------------------------------*/
2898: loaderrmsg('INV_INT_TRXACTCODE','INV_INT_TRXACTEXP');
2899:
2900: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2901: SET LAST_UPDATE_DATE = SYSDATE,
2902: LAST_UPDATED_BY = p_userid,
2903: LAST_UPDATE_LOGIN = p_loginid,
2904: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2927: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2923:
2924: loaderrmsg('INV_INT_ORGCODE','INV_INT_ORGEXP');
2925:
2926:
2927: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2928: SET LAST_UPDATE_DATE = SYSDATE,
2929: LAST_UPDATED_BY = p_userid,
2930: LAST_UPDATE_LOGIN = p_loginid,
2931: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2959: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2955:
2956: loaderrmsg('INV_INT_XORGCODE','INV_INT_XORGEXP');
2957:
2958:
2959: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2960: SET LAST_UPDATE_DATE = SYSDATE,
2961: LAST_UPDATED_BY = p_userid,
2962: LAST_UPDATE_LOGIN = p_loginid,
2963: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2994: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2990: | Validating item revisions
2991: +--------------------------------------------------*/
2992: loaderrmsg('INV_INT_REVCODE','INV_INT_REVEXP');
2993:
2994: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2995: SET LAST_UPDATE_DATE = SYSDATE,
2996: LAST_UPDATED_BY = p_userid,
2997: LAST_UPDATE_LOGIN = p_loginid,
2998: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3034: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3030:
3031: loaderrmsg('INV_INT_REVCODE','INV_INT_REVXFREXP');
3032:
3033:
3034: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3035: SET LAST_UPDATE_DATE = SYSDATE,
3036: LAST_UPDATED_BY = p_userid,
3037: LAST_UPDATE_LOGIN = p_loginid,
3038: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3078: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3074: /* Bug# 10331476 - Start : Restricting unimplemented item revisions for transactions with source type (13, 6, 3)*/
3075:
3076: loaderrmsg('INV_INT_REVCODE','INV_INT_REVEXP');
3077:
3078: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3079: SET LAST_UPDATE_DATE = SYSDATE,
3080: LAST_UPDATED_BY = p_userid,
3081: LAST_UPDATE_LOGIN = p_loginid,
3082: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3120: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3116: | Validating transaction reasons
3117: +------------------------------------------------------*/
3118: loaderrmsg('INV_INT_REACODE','INV_INT_REAEXP');
3119:
3120: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3121: SET LAST_UPDATE_DATE = SYSDATE,
3122: LAST_UPDATED_BY = p_userid,
3123: LAST_UPDATE_LOGIN = p_loginid,
3124: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3152: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3148:
3149: loaderrmsg('INV_INT_UOMCODE','INV_INT_UOMEXP');
3150:
3151:
3152: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3153: SET LAST_UPDATE_DATE = SYSDATE,
3154: LAST_UPDATED_BY = p_userid,
3155: LAST_UPDATE_LOGIN = p_loginid,
3156: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3182: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3178: +------------------------------------------------------*/
3179:
3180: loaderrmsg('INV_INT_QTYCODE','INV_INT_QTYSGNEXP');
3181:
3182: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3183: SET LAST_UPDATE_DATE = SYSDATE,
3184: LAST_UPDATED_BY = p_userid,
3185: LAST_UPDATE_LOGIN = p_loginid,
3186: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3198: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3194: AND TRANSACTION_ACTION_ID IN (1,21,32,34);
3195:
3196: l_count := SQL%ROWCOUNT;
3197:
3198: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3199: SET LAST_UPDATE_DATE = SYSDATE,
3200: LAST_UPDATED_BY = p_userid,
3201: LAST_UPDATE_LOGIN = p_loginid,
3202: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3279: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3275: IF (l_debug = 1) THEN
3276: inv_log_util.trace('validate_quantities IN (validate_group) - PASSED ' , 'INV_TXN_MANAGER_GRP', 9);
3277: END IF;
3278:
3279: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3280: SET TRANSACTION_QUANTITY = l_transaction_quantity,
3281: SECONDARY_TRANSACTION_QUANTITY = l_secondary_quantity,
3282: SECONDARY_UOM_CODE = l_secondary_uom_code
3283: WHERE ROWID = l_rowid;

Line 3307: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3303: errupdate(l_rowid, NULL);
3304: END IF;
3305: --Set the default UOM2 if missing
3306: IF (l_secondary_uom_code IS NULL) THEN
3307: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3308: SET SECONDARY_UOM_CODE = l_item_secondary_uom_code
3309: WHERE ROWID = l_rowid;
3310: END IF;
3311: END IF;--} -- Lot ctl check

Line 3314: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3310: END IF;
3311: END IF;--} -- Lot ctl check
3312: ELSE
3313: --tracking is primary. no need for sec uom/qty
3314: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3315: SET SECONDARY_TRANSACTION_QUANTITY = NULL,
3316: SECONDARY_UOM_CODE = NULL
3317: WHERE ROWID = l_rowid;
3318: END IF;--}

Line 3341: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3337: FND_MESSAGE.set_name('INV', 'INV_GREATER_THAN');
3338: l_error_code := FND_MESSAGE.get;
3339:
3340:
3341: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3342: SET LAST_UPDATE_DATE = SYSDATE,
3343: LAST_UPDATED_BY = p_userid,
3344: LAST_UPDATE_LOGIN = p_loginid,
3345: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3367: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3363: l_error_code := FND_MESSAGE.get;
3364:
3365:
3366:
3367: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3368: SET LAST_UPDATE_DATE = SYSDATE,
3369: LAST_UPDATED_BY = p_userid,
3370: LAST_UPDATE_LOGIN = p_loginid,
3371: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3399: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3395: /*Bug#5176266. Made changes to the below UPDATE statement
3396: to validate the Account effective date against transactions
3397: date( not sysdate)*/
3398:
3399: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3400: SET LAST_UPDATE_DATE = SYSDATE,
3401: LAST_UPDATED_BY = p_userid,
3402: LAST_UPDATE_LOGIN = p_loginid,
3403: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3426: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3422:
3423: l_count := SQL%ROWCOUNT;
3424:
3425:
3426: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3427: SET LAST_UPDATE_DATE = SYSDATE,
3428: LAST_UPDATED_BY = p_userid,
3429: LAST_UPDATE_LOGIN = p_loginid,
3430: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3475: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3471:
3472: loaderrmsg('INV_INT_FRTCODE','INV_INT_FRTEXP');
3473:
3474:
3475: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3476: SET LAST_UPDATE_DATE = SYSDATE,
3477: LAST_UPDATED_BY = p_userid,
3478: LAST_UPDATE_LOGIN = p_loginid,
3479: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3499: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3495: l_count := SQL%ROWCOUNT;
3496: loaderrmsg('INV_INT_FRTACTCODE','INV_INT_FRTACTEXP');
3497:
3498:
3499: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3500: SET LAST_UPDATE_DATE = SYSDATE,
3501: LAST_UPDATED_BY = p_userid,
3502: LAST_UPDATE_LOGIN = p_loginid,
3503: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3539: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3535:
3536:
3537: IF srctypeid = 5 THEN
3538:
3539: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3540: SET LAST_UPDATE_DATE = SYSDATE,
3541: LAST_UPDATED_BY = p_userid,
3542: LAST_UPDATE_LOGIN = p_loginid,
3543: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3578: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3574:
3575: IF (srctypeid = 5 AND wip_constants.dmf_patchset_level< wip_constants.DMF_PATCHSET_J_VALUE) THEN --J-dev
3576: loaderrmsg('INV_INT_SRCCODE','INV_INT_SRCCFMEXP');
3577: IF srctypeid = 5 THEN
3578: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3579: SET LAST_UPDATE_DATE = SYSDATE,
3580: LAST_UPDATED_BY = p_userid,
3581: LAST_UPDATE_LOGIN = p_loginid,
3582: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3614: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3610: IF (l_validate_full) THEN --J-dev
3611:
3612: loaderrmsg('INV_PROJCON_ERR','INV_PROJCON_ERR');
3613:
3614: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3615: SET LAST_UPDATE_DATE = SYSDATE,
3616: LAST_UPDATED_BY = p_userid,
3617: LAST_UPDATE_LOGIN = p_loginid,
3618: PROCESS_FLAG = 3,

Line 3641: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3637: /* validate source task id */
3638: loaderrmsg('INV_TASK_ERR','INV_TASK_ERR');
3639:
3640:
3641: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3642: SET LAST_UPDATE_DATE = SYSDATE,
3643: LAST_UPDATED_BY = p_userid,
3644: LAST_UPDATE_LOGIN = p_loginid,
3645: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3696: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3692:
3693: loaderrmsg('INV_ETYPE_ERR','INV_ETYPE_ERR');
3694: IF exp_type_required = 2 THEN
3695:
3696: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3697: SET LAST_UPDATE_DATE = SYSDATE,
3698: LAST_UPDATED_BY = p_userid,
3699: LAST_UPDATE_LOGIN = p_loginid,
3700: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3730: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3726:
3727: l_count := l_count + SQL%ROWCOUNT;
3728:
3729: ELSE
3730: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3731: SET LAST_UPDATE_DATE = SYSDATE,
3732: LAST_UPDATED_BY = p_userid,
3733: LAST_UPDATE_LOGIN = p_loginid,
3734: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3763: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3759: | enabled in terms of date |
3760: +--------------------------------------------------------------+*/
3761: loaderrmsg('INV_INT_CSTGRP','INV_INT_CSTEXP');
3762:
3763: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3764: SET LAST_UPDATE_DATE = SYSDATE,
3765: LAST_UPDATED_BY = p_userid,
3766: LAST_UPDATE_LOGIN = p_loginid,
3767: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3799: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3795: | enabled in terms of date |
3796: +-----------------------------------------------------------------------+*/
3797: loaderrmsg('INV_INT_XCSTGRP','INV_INT_XCSTEXP');
3798:
3799: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3800: SET LAST_UPDATE_DATE = SYSDATE,
3801: LAST_UPDATED_BY = p_userid,
3802: LAST_UPDATE_LOGIN = p_loginid,
3803: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3838: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3834: 'using_organization_code' is set to -1 in the table, 'po_asl_attributes' if
3835: the global flag is set to 'Yes' in the ASL for an (item, supplier)
3836: combination*/
3837:
3838: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3839: SET LAST_UPDATE_DATE = SYSDATE,
3840: LAST_UPDATED_BY = p_userid,
3841: LAST_UPDATE_LOGIN = p_loginid,
3842: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3868: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3864:
3865: --if the planning _org is a inventory org it should be in
3866: --mtl_parameters.
3867:
3868: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3869: SET LAST_UPDATE_DATE = SYSDATE,
3870: LAST_UPDATED_BY = p_userid,
3871: LAST_UPDATE_LOGIN = p_loginid,
3872: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3902: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3898:
3899: loaderrmsg('INV_INT_LPN','INV_INT_LPN');
3900:
3901:
3902: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3903: SET LAST_UPDATE_DATE = SYSDATE,
3904: LAST_UPDATED_BY = p_userid,
3905: LAST_UPDATE_LOGIN = p_loginid,
3906: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3928: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3924: END IF;
3925:
3926: --Validate Xfr LPN
3927:
3928: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3929: SET LAST_UPDATE_DATE = SYSDATE,
3930: LAST_UPDATED_BY = p_userid,
3931: LAST_UPDATE_LOGIN = p_loginid,
3932: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4047: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4043:
4044:
4045: --Validate Content LPN
4046:
4047: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4048: SET LAST_UPDATE_DATE = SYSDATE,
4049: LAST_UPDATED_BY = p_userid,
4050: LAST_UPDATE_LOGIN = p_loginid,
4051: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4082: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4078:
4079: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR
4080: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR
4081: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN
4082: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4083: SET LAST_UPDATE_DATE = SYSDATE,
4084: LAST_UPDATED_BY = p_userid,
4085: LAST_UPDATE_LOGIN = p_loginid,
4086: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4110: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4106:
4107: IF (srctypeid = 5 AND wip_constants.dmf_patchset_level< wip_constants.DMF_PATCHSET_J_VALUE) THEN --J-dev
4108:
4109: IF (srctypeid = 5) THEN
4110: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4111: SET LAST_UPDATE_DATE = SYSDATE,
4112: LAST_UPDATED_BY = p_userid,
4113: LAST_UPDATE_LOGIN = p_loginid,
4114: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4135: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4131: /*-------------------------------------------------------------+
4132: | Update MTI with right op seq num for non-CFMs
4133: +--------------------------------------------------------------*/
4134:
4135: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4136: SET LAST_UPDATE_DATE = SYSDATE,
4137: LAST_UPDATED_BY = p_userid,
4138: LAST_UPDATE_LOGIN = p_loginid,
4139: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4160: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4156: +--------------------------------------------------------------*/
4157:
4158: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
4159:
4160: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4161: SET LAST_UPDATE_DATE = SYSDATE,
4162: LAST_UPDATED_BY = p_userid,
4163: LAST_UPDATE_LOGIN = p_loginid,
4164: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4172: FROM MTL_TRANSACTIONS_INTERFACE MTI2

4168: WHERE TRANSACTION_HEADER_ID = p_header_id
4169: AND PROCESS_FLAG = 1
4170: AND EXISTS
4171: (SELECT 'Y'
4172: FROM MTL_TRANSACTIONS_INTERFACE MTI2
4173: WHERE MTI2.TRANSACTION_HEADER_ID = p_header_id
4174: AND MTI2.PROCESS_FLAG = 3
4175: AND MTI2.ERROR_CODE IS NOT NULL
4176: AND MTI2.TRANSACTION_BATCH_ID = MTI.TRANSACTION_BATCH_ID);

Line 4182: FROM MTL_TRANSACTIONS_INTERFACE MTI2

4178: /* Commented following and Added EXISTS clause above for bug 8444982
4179:
4180: AND TRANSACTION_BATCH_ID IN
4181: (SELECT DISTINCT MTI2.TRANSACTION_BATCH_ID
4182: FROM MTL_TRANSACTIONS_INTERFACE MTI2
4183: WHERE MTI2.TRANSACTION_HEADER_ID = p_header_id
4184: AND MTI2.PROCESS_FLAG = 3
4185: AND MTI2.ERROR_CODE IS NOT NULL);
4186:

Line 4203: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4199:
4200: /* Bug# 5264549 : made changes to the REBUILD_ITEM_ID query to
4201: update EAM validations from Transaction Manager */
4202:
4203: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4204: SET LAST_UPDATE_DATE = SYSDATE,
4205: LAST_UPDATED_BY = p_userid,
4206: LAST_UPDATE_LOGIN = p_loginid,
4207: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4359: FROM MTL_TRANSACTIONS_INTERFACE

4355:
4356: -- nsinghi bug 5209065. Added the cursor.
4357: CURSOR cur_get_interface_id IS
4358: SELECT transaction_interface_id
4359: FROM MTL_TRANSACTIONS_INTERFACE
4360: WHERE ROWID = p_rowid;
4361:
4362: l_item_copy_lot_attribute_flag VARCHAR2(1);
4363: l_org_copy_lot_attribute_flag VARCHAR2(1);

Line 4450: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4446: --WHENEVER NOT FOUND CONTINUE;
4447:
4448: loaderrmsg('INV_INT_LOTCODE','INV_INT_LOTEXP');
4449:
4450: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4451: SET LAST_UPDATE_DATE = SYSDATE,
4452: LAST_UPDATED_BY = l_userid,
4453: LAST_UPDATE_LOGIN = l_loginid,
4454: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4493: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4489: IF SQL%FOUND THEN
4490: FND_MESSAGE.set_name('INV','INV_INT_LOTUNIQEXP');
4491: l_error_exp := FND_MESSAGE.get;
4492:
4493: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4494: SET LAST_UPDATE_DATE = SYSDATE,
4495: LAST_UPDATED_BY = l_userid,
4496: LAST_UPDATE_LOGIN = l_loginid,
4497: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4793: UPDATE MTL_TRANSACTIONS_INTERFACE

4789: REQUEST_ID = l_reqstid,
4790: ERROR_CODE = substrb(l_error_code,1,240)
4791: WHERE ROWID = l_lotrowid;
4792:
4793: UPDATE MTL_TRANSACTIONS_INTERFACE
4794: SET ERROR_CODE = substrb(l_error_code,1,240),
4795: ERROR_EXPLANATION = substrb(l_error_exp,1,240),
4796: LAST_UPDATE_DATE = sysdate,
4797: LAST_UPDATED_BY = l_userid,

Line 4844: UPDATE MTL_TRANSACTIONS_INTERFACE

4840: REQUEST_ID = l_reqstid,
4841: ERROR_CODE = substrb(l_error_code,1,240)
4842: WHERE ROWID = l_lotrowid;
4843:
4844: UPDATE MTL_TRANSACTIONS_INTERFACE
4845: SET ERROR_CODE = substrb(l_error_code,1,240),
4846: ERROR_EXPLANATION = substrb(l_error_exp,1,240),
4847: LAST_UPDATE_DATE = sysdate,
4848: LAST_UPDATED_BY = l_userid,

Line 4901: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4897: REQUEST_ID = l_reqstid,
4898: ERROR_CODE = substrb(l_error_code,1,240)
4899: WHERE ROWID = l_lotrowid;
4900:
4901: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4902: SET LAST_UPDATE_DATE = SYSDATE,
4903: LAST_UPDATED_BY = l_userid,
4904: LAST_UPDATE_LOGIN = l_loginid,
4905: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4965: mtl_transactions_interface mti

4961: AND EXISTS
4962: (
4963: select 'comingling exists'
4964: from mtl_onhand_quantities_detail moqd,
4965: mtl_transactions_interface mti
4966: WHERE mti.TRANSACTION_INTERFACE_ID = p_intid
4967: AND PROCESS_FLAG = 1
4968: AND moqd.organization_id = mti.organization_id
4969: AND moqd.inventory_item_id = mti.inventory_item_id

Line 4981: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4977: IF SQL%FOUND THEN
4978: FND_MESSAGE.set_name('INV','INV_STATUS_COMINGLING');
4979: l_error_exp := FND_MESSAGE.get;
4980:
4981: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4982: SET LAST_UPDATE_DATE = SYSDATE,
4983: LAST_UPDATED_BY = l_loginid,
4984: LAST_UPDATE_LOGIN = l_loginid,
4985: PROGRAM_UPDATE_DATE = SYSDATE,

Line 5020: UPDATE MTL_TRANSACTIONS_INTERFACE

5016: WHEN OTHERS THEN
5017: FND_MESSAGE.set_name('INV','INV_INT_UOMCONVCODE');
5018:
5019: --WHENEVER SQL ERROR CONTINUE;
5020: UPDATE MTL_TRANSACTIONS_INTERFACE
5021: SET LAST_UPDATE_DATE = SYSDATE,
5022: LAST_UPDATED_BY = l_userid,
5023: LAST_UPDATE_LOGIN = l_loginid,
5024: PROGRAM_UPDATE_DATE = SYSDATE,

Line 5266: FROM mtl_transactions_interface mti

5262: l_segs1(17),
5263: l_segs1(18),
5264: l_segs1(19),
5265: l_segs1(20)
5266: FROM mtl_transactions_interface mti
5267: WHERE mti.rowid = p_rowid;
5268:
5269: return getloc(x_locid, p_org_id, p_locctrl, l_segs1);
5270:

Line 5344: FROM mtl_transactions_interface mti

5340: l_segs1(17),
5341: l_segs1(18),
5342: l_segs1(19),
5343: l_segs1(20)
5344: FROM mtl_transactions_interface mti
5345: WHERE mti.rowid = p_rowid;
5346:
5347: return getloc(x_locid, p_org_id, p_locctrl, l_segs1);
5348:

Line 5427: FROM mtl_transactions_interface mti

5423: l_segs1(20)
5424:
5425:
5426:
5427: FROM mtl_transactions_interface mti
5428: WHERE mti.rowid = p_rowid;
5429:
5430: return getloc(x_locid, p_org_id, p_locctrl, l_segs1);
5431:

Line 5510: FROM mtl_transactions_interface mti

5506: l_segs1(19),
5507: l_segs1(20)
5508:
5509:
5510: FROM mtl_transactions_interface mti
5511: WHERE mti.rowid = p_rowid;
5512:
5513: return getloc(x_locid, p_org_id, p_locctrl, l_segs1);
5514:

Line 5717: RETURN mtl_transactions_interface.cost_group_id%TYPE IS

5713: * Added for Bug 6356567
5714: ******************************************************************/
5715:
5716: FUNCTION get_costgrpid(p_org_id in NUMBER, p_subinv in VARCHAR2, p_locatorid in NUMBER)
5717: RETURN mtl_transactions_interface.cost_group_id%TYPE IS
5718: l_cost_group_id number;
5719: l_org_cost_group_id number;
5720: l_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
5721: l_project_enabled NUMBER;

Line 6457: FROM MTL_TRANSACTIONS_INTERFACE

6453: ,wip_entity_type -- Pawan 11th july added
6454: /*Bug:5392366. Added the following two columns. */
6455: ,completion_transaction_id
6456: ,move_transaction_id
6457: FROM MTL_TRANSACTIONS_INTERFACE
6458: WHERE TRANSACTION_HEADER_ID = p_header_id
6459: AND PROCESS_FLAG = 1
6460: ORDER BY ORGANIZATION_ID,INVENTORY_ITEM_ID,REVISION,
6461: SUBINVENTORY_CODE,LOCATOR_ID;

Line 6511: * Validate one transaction record in MTL_TRANSACTIONS_INTERFACE

6507:
6508: /******************************************************************
6509: *
6510: * validate_lines()
6511: * Validate one transaction record in MTL_TRANSACTIONS_INTERFACE
6512: *
6513: ******************************************************************/
6514: PROCEDURE validate_lines(p_line_Rec_Type inv_txn_manager_pub.line_rec_type,
6515: p_commit VARCHAR2 := fnd_api.g_false ,

Line 6744: from mtl_transactions_interface

6740: --bug#13527319 getting the op_seq and wip_supply information, we are to skip validation on phantom component
6741: --issue. the way to identify is wip_supply_type=6 and op_seq_num negative
6742: select nvl(operation_seq_num,1 ),nvl(wip_supply_type,1)
6743: into l_operation_seq_num, l_wip_supply_type
6744: from mtl_transactions_interface
6745: where ROWID = l_rowid;
6746: IF (l_debug = 1) THEN
6747: inv_log_util.trace('operation_seq_num '||l_operation_seq_num||' l_wip_supply_type '||l_wip_supply_type, 'INV_TXN_MANAGER_PUB', 9);
6748: END IF;

Line 6828: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

6824: inv_log_util.trace('#$l_rowid '||l_rowid, 'INV_TXN_MANAGER_GRP', 9);
6825: END IF;
6826:
6827:
6828: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
6829: SET LAST_UPDATE_DATE = SYSDATE,
6830: LAST_UPDATED_BY = p_userid,
6831: LAST_UPDATE_LOGIN = p_loginid,
6832: PROGRAM_UPDATE_DATE = SYSDATE,

Line 6890: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

6886: /* validate Negative transaction cost */
6887:
6888: loaderrmsg('INV_UNIT_COST_NEG','INV_UNIT_COST_NEG');
6889:
6890: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
6891: SET LAST_UPDATE_DATE = SYSDATE,
6892: LAST_UPDATED_BY = p_userid,
6893: LAST_UPDATE_LOGIN = p_loginid,
6894: PROGRAM_UPDATE_DATE = SYSDATE,

Line 6936: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

6932: /* validate expenditure org id */
6933:
6934: loaderrmsg('INV_PAORG_ERR','INV_PAORG_ERR');
6935:
6936: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
6937: SET LAST_UPDATE_DATE = SYSDATE,
6938: LAST_UPDATED_BY = p_userid,
6939: LAST_UPDATE_LOGIN = p_loginid,
6940: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7219: FROM MTL_TRANSACTIONS_INTERFACE

7215: IF l_srctype = 5 THEN
7216: BEGIN
7217: SELECT DECODE(UPPER(NVL(FLOW_SCHEDULE,'N')), 'Y', 1, 0), NVL(SCHEDULED_FLAG, 0)
7218: INTO tev_flow_schedule, tev_scheduled_flag
7219: FROM MTL_TRANSACTIONS_INTERFACE
7220: WHERE ROWID = l_rowid;
7221: EXCEPTION
7222: WHEN NO_DATA_FOUND THEN
7223: tev_flow_schedule := 0;

Line 7681: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7677: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7678: fnd_message.set_token('ACCOUNT',l_account);
7679: l_error_exp := fnd_message.get;
7680:
7681: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7682: SET LAST_UPDATE_DATE = SYSDATE,
7683: LAST_UPDATED_BY = p_userid,
7684: LAST_UPDATE_LOGIN = p_loginid,
7685: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7729: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7725: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7726: fnd_message.set_token('ACCOUNT',l_account);
7727: l_error_exp := fnd_message.get;
7728:
7729: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7730: SET LAST_UPDATE_DATE = SYSDATE,
7731: LAST_UPDATED_BY = p_userid,
7732: LAST_UPDATE_LOGIN = p_loginid,
7733: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7776: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7772: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7773: fnd_message.set_token('ACCOUNT',l_account);
7774: l_error_exp := fnd_message.get;
7775:
7776: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7777: SET LAST_UPDATE_DATE = SYSDATE,
7778: LAST_UPDATED_BY = p_userid,
7779: LAST_UPDATE_LOGIN = p_loginid,
7780: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7823: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7819: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7820: fnd_message.set_token('ACCOUNT',l_account);
7821: l_error_exp := fnd_message.get;
7822:
7823: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7824: SET LAST_UPDATE_DATE = SYSDATE,
7825: LAST_UPDATED_BY = p_userid,
7826: LAST_UPDATE_LOGIN = p_loginid,
7827: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7870: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7866: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7867: fnd_message.set_token('ACCOUNT',l_account);
7868: l_error_exp := fnd_message.get;
7869:
7870: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7871: SET LAST_UPDATE_DATE = SYSDATE,
7872: LAST_UPDATED_BY = p_userid,
7873: LAST_UPDATE_LOGIN = p_loginid,
7874: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8428: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8424: l_count := l_count + 1;
8425: END;
8426: END IF;
8427:
8428: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8429: SET LAST_UPDATE_DATE = SYSDATE,
8430: LAST_UPDATED_BY = p_userid,
8431: LAST_UPDATE_LOGIN = p_loginid,
8432: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8462: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8458: | Validating locators
8459: +-------------------------------------------------------------*/
8460: loaderrmsg('INV_INT_LOCCODE','INV_INT_LOCEXP');
8461:
8462: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8463: SET LAST_UPDATE_DATE = SYSDATE,
8464: LAST_UPDATED_BY = p_userid,
8465: LAST_UPDATE_LOGIN = p_loginid,
8466: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8486: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8482:
8483:
8484: loaderrmsg('INV_INT_LOCCODE','INV_INT_RESLOCEXP');
8485:
8486: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8487: SET LAST_UPDATE_DATE = SYSDATE,
8488: LAST_UPDATED_BY = p_userid,
8489: LAST_UPDATE_LOGIN = p_loginid,
8490: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8529: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8525: +-----------------------------------------------------------*/
8526:
8527: loaderrmsg('INV_INT_XLOCCODE','INV_INT_XFRLOCEXP');
8528:
8529: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8530: SET LAST_UPDATE_DATE = SYSDATE,
8531: LAST_UPDATED_BY = p_userid,
8532: LAST_UPDATE_LOGIN = p_loginid,
8533: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8559: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8555: | Validating transfer locators for restricted list
8556: +------------------------------------------------------*/
8557: loaderrmsg('INV_INT_XLOCCODE','INV_INT_RESXFRLOCEXP');
8558:
8559: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8560: SET LAST_UPDATE_DATE = SYSDATE,
8561: LAST_UPDATED_BY = p_userid,
8562: LAST_UPDATE_LOGIN = p_loginid,
8563: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8763: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8759: IF (l_debug = 1) THEN
8760: inv_log_util.trace('Updating MTI with transfer price: ' || l_transfer_price_priuom, 'INV_TXN_MANAGER_GRP','1');
8761: END IF;
8762:
8763: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8764: SET LAST_UPDATE_DATE = SYSDATE,
8765: LAST_UPDATED_BY = p_userid,
8766: LAST_UPDATE_LOGIN = p_loginid,
8767: transfer_price = l_transfer_price_priuom

Line 8803: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8799: IF (l_lotctrl=2 AND p_line_Rec_Type.secondary_uom_code IS NOT NULL) THEN
8800: IF (l_debug = 1) THEN
8801: inv_log_util.trace('update secondary quantity on line as sum of lot level secondary quantities', 'INV_TXN_MANAGER_GRP', 9);
8802: END IF;
8803: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8804: SET secondary_transaction_quantity = (SELECT SUM(SECONDARY_TRANSACTION_QUANTITY)
8805: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI
8806: WHERE MTLI.TRANSACTION_INTERFACE_ID = p_line_Rec_Type.TRANSACTION_INTERFACE_ID)
8807: WHERE ROWID = l_rowid;

Line 8817: FROM MTL_TRANSACTIONS_INTERFACE

8813: +--------------------------------------------------------------*/
8814:
8815: SELECT cost_group_id, transfer_cost_group_id
8816: INTO l_cost_group_id, l_xfer_cost_group_id
8817: FROM MTL_TRANSACTIONS_INTERFACE
8818: WHERE ROWID = l_rowid
8819: AND PROCESS_FLAG = 1;
8820:
8821: IF l_cost_group_id is not null and l_acttype not in (5,6,24,30,50,51,52) THEN -- Modified 7025628

Line 8825: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8821: IF l_cost_group_id is not null and l_acttype not in (5,6,24,30,50,51,52) THEN -- Modified 7025628
8822: l_temp_cost_group_id := get_costgrpid(l_orgid, l_subinv, l_locid);
8823: loaderrmsg('INV_INT_CSTGRP','INV_INT_CSTEXP');
8824:
8825: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8826: SET LAST_UPDATE_DATE = SYSDATE,
8827: LAST_UPDATED_BY = p_userid,
8828: LAST_UPDATE_LOGIN = p_loginid,
8829: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8863: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8859:
8860: l_temp_xfer_cost_group_id := get_costgrpid(l_cg_org, l_xsubinv, l_xlocid);
8861: loaderrmsg('INV_INT_XCSTGRP','INV_INT_XCSTEXP');
8862:
8863: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8864: SET LAST_UPDATE_DATE = SYSDATE,
8865: LAST_UPDATED_BY = p_userid,
8866: LAST_UPDATE_LOGIN = p_loginid,
8867: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8907: UPDATE MTL_TRANSACTIONS_INTERFACE

8903: FND_MESSAGE.set_name('INV', 'INV_SERIAL_USED');
8904: l_error_code := FND_MESSAGE.get;
8905: l_error_exp := l_error_code;
8906:
8907: UPDATE MTL_TRANSACTIONS_INTERFACE
8908: SET LAST_UPDATE_DATE = SYSDATE,
8909: LAST_UPDATED_BY = p_userid,
8910: LAST_UPDATE_LOGIN = p_loginid,
8911: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8922: mtl_transactions_interface mti, mtl_material_transactions_temp mmtt

8918: AND (
8919: EXISTS
8920: (
8921: select 1 FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,
8922: mtl_transactions_interface mti, mtl_material_transactions_temp mmtt
8923: WHERE msn.serial_number BETWEEN msni.fm_serial_number AND msni.to_serial_number
8924: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
8925: AND msn.current_organization_id = mti.organization_id
8926: AND msn.inventory_item_id = mti.inventory_item_id

Line 8939: mtl_transactions_interface mti,mtl_transaction_lots_interface mtli,

8935: OR EXISTS
8936: (
8937: select msn.serial_number, msn.group_mark_id,mti.transaction_interface_id
8938: FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,
8939: mtl_transactions_interface mti,mtl_transaction_lots_interface mtli,
8940: mtl_material_transactions_temp mmtt
8941: WHERE msn.serial_number BETWEEN msni.fm_serial_number AND msni.to_serial_number
8942: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
8943: AND msn.current_organization_id = mti.organization_id

Line 8966: UPDATE MTL_TRANSACTIONS_INTERFACE

8962: inv_log_util.trace('Error in validate_line : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
8963: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
8964: END IF;
8965:
8966: UPDATE MTL_TRANSACTIONS_INTERFACE
8967: SET LAST_UPDATE_DATE = SYSDATE,
8968: LAST_UPDATED_BY = p_userid,
8969: LAST_UPDATE_LOGIN = p_loginid,
8970: PROGRAM_UPDATE_DATE = SYSDATE,

Line 9102: FROM mtl_transactions_interface

9098: SELECT 1
9099: INTO l_count
9100: FROM DUAL
9101: WHERE EXISTS (SELECT transaction_interface_id
9102: FROM mtl_transactions_interface
9103: WHERE transaction_header_id = p_header_id
9104: AND process_flag = 1
9105: AND transaction_type_id NOT IN
9106: (inv_globals.g_type_inv_lot_split

Line 9466: FROM MTL_TRANSACTIONS_INTERFACE

9462: RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9463: RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9464: TRANSFER_PRICE, -- INVCONV umoogala For Process-Discrete Transfer Enh.
9465: scheduled_payback_date --BUG 7683172
9466: FROM MTL_TRANSACTIONS_INTERFACE
9467: --WHERE ROWID = p_rowid--J-dev
9468: WHERE transaction_header_id = p_header_id
9469: AND PROCESS_FLAG = 1
9470: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/

Line 9812: FROM MTL_TRANSACTIONS_INTERFACE MTI,

9808: mti.SECONDARY_UOM_CODE, -- INVCONV fabdi
9809: mti.RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9810: mti.RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9811: mti.TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
9812: FROM MTL_TRANSACTIONS_INTERFACE MTI,
9813: BOM_BILL_OF_MATERIALS BOM,
9814: BOM_OPERATIONAL_ROUTINGS BOR
9815: WHERE TRANSACTION_HEADER_ID = p_header_id
9816: /*WHERE MTI.ROWID = p_rowid*/--J-dev

Line 10166: FROM MTL_TRANSACTIONS_INTERFACE MTI

10162: mti.SECONDARY_UOM_CODE, -- INVCONV fabdi end
10163: mti.RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
10164: mti.RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
10165: mti.TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
10166: FROM MTL_TRANSACTIONS_INTERFACE MTI
10167: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
10168: and MTI.PROCESS_FLAG = 1
10169: and MTI.TRANSACTION_ACTION_ID IN (1, 27, 33, 34) ;
10170:

Line 10490: FROM MTL_TRANSACTIONS_INTERFACE MTI,

10486: mti.SECONDARY_UOM_CODE, -- INVCONV fabdi end
10487: mti.RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
10488: mti.RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
10489: mti.TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
10490: FROM MTL_TRANSACTIONS_INTERFACE MTI,
10491: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
10492: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
10493: /* WHERE MTI.ROWID = p_rowid J-dev*/
10494: and MTI.PROCESS_FLAG = 1

Line 10742: FROM MTL_TRANSACTIONS_INTERFACE MTI

10738: parent_object_number2 --R12 Genealogy enhancements
10739: FROM MTL_TRANSACTION_LOTS_INTERFACE
10740: WHERE TRANSACTION_INTERFACE_ID IN (
10741: SELECT TRANSACTION_INTERFACE_ID
10742: FROM MTL_TRANSACTIONS_INTERFACE MTI
10743: WHERE mti.TRANSACTION_HEADER_ID = p_header_id
10744: /*WHERE MTI.ROWID = p_rowid J-dev*/
10745: AND mti.TRANSACTION_INTERFACE_ID IS NOT NULL
10746: AND mti.PROCESS_FLAG = 1

Line 10922: FROM MTL_TRANSACTIONS_INTERFACE MTI

10918: parent_object_number2 --R12 Genealogy enhancements
10919: FROM MTL_SERIAL_NUMBERS_INTERFACE
10920: WHERE (TRANSACTION_INTERFACE_ID IN (
10921: SELECT TRANSACTION_INTERFACE_ID
10922: FROM MTL_TRANSACTIONS_INTERFACE MTI
10923: WHERE TRANSACTION_HEADER_ID = p_header_id
10924: /*WHERE MTI.ROWID = p_rowid*/--J-dev
10925: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10926: AND PROCESS_FLAG = 1

Line 10937: FROM MTL_TRANSACTIONS_INTERFACE

10933: SELECT SERIAL_TRANSACTION_TEMP_ID
10934: FROM MTL_TRANSACTION_LOTS_INTERFACE
10935: WHERE TRANSACTION_INTERFACE_ID IN (
10936: SELECT TRANSACTION_INTERFACE_ID
10937: FROM MTL_TRANSACTIONS_INTERFACE
10938: WHERE TRANSACTION_HEADER_ID = p_header_id
10939: /*WHERE rowid = p_rowid J-dev*/
10940: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10941: AND PROCESS_FLAG = 1

Line 11332: || ' mtl_transactions_interface mti'

11328: l_select_stmt
11329: || ' from mtl_serial_numbers_interface msni,'
11330: || ' mtl_serial_numbers msn,'
11331: || ' mtl_transaction_lots_interface mtli,'
11332: || ' mtl_transactions_interface mti'
11333: || ' where mti.parent_id = :b_parent_id'
11334: || ' and mti.transaction_interface_id <> mti.parent_id'
11335: || ' and mtli.transaction_interface_id = mti.transaction_interface_id'
11336: || ' and msni.transaction_interface_id = mtli.serial_transaction_temp_id'

Line 11658: FROM mtl_transactions_interface mti

11654: , mti.secondary_transaction_quantity
11655: , mti.secondary_uom_code
11656: , mti.relieve_reservations_flag /*** {{ R12 Enhanced reservations code changes ***/
11657: , mti.relieve_high_level_rsv_flag /*** {{ R12 Enhanced reservations code changes ***/
11658: FROM mtl_transactions_interface mti
11659: WHERE mti.transaction_header_id = l_header_id
11660: AND mti.transaction_action_id IN
11661: (inv_globals.g_action_inv_lot_split
11662: , inv_globals.g_action_inv_lot_merge

Line 12089: FROM mtl_transactions_interface mti

12085: , mtli.serial_transaction_temp_id
12086: FROM mtl_transaction_lots_interface mtli
12087: WHERE mtli.transaction_interface_id =
12088: (SELECT mti.transaction_interface_id
12089: FROM mtl_transactions_interface mti
12090: WHERE mti.parent_id = l_transaction_interface_id
12091: AND mti.transaction_interface_id <> mti.parent_id);
12092:
12093: l_parent_id NUMBER;

Line 13485: FROM mtl_transactions_interface mti

13481: ,l_old_lot_num
13482: ,l_old_sub_code
13483: ,l_old_locator_id
13484: ,l_old_lpn_id
13485: FROM mtl_transactions_interface mti
13486: ,mtl_transaction_lots_interface mtli
13487: WHERE mti.transaction_interface_id = mtli.transaction_interface_id
13488: AND mti.transaction_interface_id = mti.parent_id
13489: AND mti.transaction_interface_id = l_mti_csr.parent_id;

Line 14144: FROM MTL_TRANSACTIONS_INTERFACE

14140: ,WIP_ENTITY_TYPE -- Pawan 11th july added for subinventory issue
14141: /*Bug:5392366. Added following two columns. */
14142: ,COMPLETION_TRANSACTION_ID
14143: ,MOVE_TRANSACTION_ID
14144: FROM MTL_TRANSACTIONS_INTERFACE
14145: WHERE TRANSACTION_HEADER_ID = p_header_id
14146: AND PROCESS_FLAG = 1
14147: /* added for bug 4634810 */
14148: AND NOT( transaction_source_type_id = 5 AND

Line 14293: FROM MTL_TRANSACTIONS_INTERFACE

14289: +--------------------------------------------------------------+ */
14290: BEGIN
14291: SELECT DECODE(UPPER(FLOW_SCHEDULE),'Y', 1, 0)
14292: INTO gi_flow_schedule
14293: FROM MTL_TRANSACTIONS_INTERFACE
14294: WHERE TRANSACTION_HEADER_ID = l_header_id
14295: AND TRANSACTION_SOURCE_TYPE_ID = 5
14296: AND TRANSACTION_ACTION_ID IN (30,31, 32) --CFM Scrap Transactions
14297: AND PROCESS_FLAG = 1

Line 14375: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14371:
14372: --check for batch error at line validation
14373: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14374:
14375: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14376: SET LAST_UPDATE_DATE = SYSDATE,
14377: LAST_UPDATED_BY = l_userid,
14378: LAST_UPDATE_LOGIN = l_loginid,
14379: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14387: FROM MTL_TRANSACTIONS_INTERFACE MTI2

14383: WHERE TRANSACTION_HEADER_ID = l_header_id
14384: AND PROCESS_FLAG = 1
14385: AND EXISTS
14386: (SELECT 'Y'
14387: FROM MTL_TRANSACTIONS_INTERFACE MTI2
14388: WHERE MTI2.TRANSACTION_HEADER_ID = l_header_id
14389: AND MTI2.PROCESS_FLAG = 3
14390: AND MTI2.ERROR_CODE IS NOT NULL
14391: AND MTI2.TRANSACTION_BATCH_ID = MTI.TRANSACTION_BATCH_ID);

Line 14396: FROM MTL_TRANSACTIONS_INTERFACE MTI2

14392:
14393: /* Commented following and Added EXISTS clause above for bug 8444982
14394: AND TRANSACTION_BATCH_ID IN
14395: (SELECT DISTINCT MTI2.TRANSACTION_BATCH_ID
14396: FROM MTL_TRANSACTIONS_INTERFACE MTI2
14397: WHERE MTI2.TRANSACTION_HEADER_ID = l_header_id
14398: AND MTI2.PROCESS_FLAG = 3
14399: AND MTI2.ERROR_CODE IS NOT NULL);
14400: */

Line 14479: FROM mtl_transactions_interface

14475: IF ( NOT l_current_batch_failed) THEN --350
14476: BEGIN
14477: SELECT demand_source_header_id , demand_source_line
14478: INTO l_dem_hdr_id,l_dem_line_id
14479: FROM mtl_transactions_interface
14480: WHERE
14481: ROWID = l_temp_rowid ;
14482: EXCEPTION
14483: WHEN OTHERS THEN

Line 14491: UPDATE MTL_TRANSACTIONS_INTERFACE

14487: END IF;
14488: l_error_code := 'Error in getting Demand Info';
14489: l_error_exp := 'Error in getting Demand Info';
14490:
14491: UPDATE MTL_TRANSACTIONS_INTERFACE
14492: SET LAST_UPDATE_DATE = SYSDATE,
14493: LAST_UPDATED_BY = l_userid,
14494: LAST_UPDATE_LOGIN = l_loginid,
14495: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14506: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14502:
14503: --check for batch error
14504: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14505:
14506: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14507: SET LAST_UPDATE_DATE = SYSDATE,
14508: LAST_UPDATED_BY = l_userid,
14509: LAST_UPDATE_LOGIN = l_loginid,
14510: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14594: UPDATE MTL_TRANSACTIONS_INTERFACE

14590: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
14591: l_error_code := FND_MESSAGE.get;
14592: l_error_exp := l_msg_data;
14593: x_msg_data := l_msg_data;
14594: UPDATE MTL_TRANSACTIONS_INTERFACE
14595: SET LAST_UPDATE_DATE = SYSDATE,
14596: LAST_UPDATED_BY = l_userid,
14597: LAST_UPDATE_LOGIN = l_loginid,
14598: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14609: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14605:
14606: --check for batch error
14607: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14608:
14609: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14610: SET LAST_UPDATE_DATE = SYSDATE,
14611: LAST_UPDATED_BY = l_userid,
14612: LAST_UPDATE_LOGIN = l_loginid,
14613: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14661: UPDATE MTL_TRANSACTIONS_INTERFACE

14657: FND_MESSAGE.set_token('token1','XACT_QTY1');
14658: l_error_code := FND_MESSAGE.get;
14659: l_error_exp := l_msg_data;
14660: x_msg_data := l_msg_data;
14661: UPDATE MTL_TRANSACTIONS_INTERFACE
14662: SET LAST_UPDATE_DATE = SYSDATE,
14663: LAST_UPDATED_BY = l_userid,
14664: LAST_UPDATE_LOGIN = l_loginid,
14665: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14675: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14671: AND PROCESS_FLAG = 1;
14672: --check for batch error
14673: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14674:
14675: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14676: SET LAST_UPDATE_DATE = SYSDATE,
14677: LAST_UPDATED_BY = l_userid,
14678: LAST_UPDATE_LOGIN = l_loginid,
14679: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14702: UPDATE MTL_TRANSACTIONS_INTERFACE

14698: FND_MESSAGE.set_token('token1','XACT_QTY1');
14699: l_error_code := FND_MESSAGE.get;
14700: l_error_exp := l_msg_data;
14701: x_msg_data := l_msg_data;
14702: UPDATE MTL_TRANSACTIONS_INTERFACE
14703: SET LAST_UPDATE_DATE = SYSDATE,
14704: LAST_UPDATED_BY = l_userid,
14705: LAST_UPDATE_LOGIN = l_loginid,
14706: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14716: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14712: AND PROCESS_FLAG = 1;
14713: --check for batch error
14714: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14715:
14716: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14717: SET LAST_UPDATE_DATE = SYSDATE,
14718: LAST_UPDATED_BY = l_userid,
14719: LAST_UPDATE_LOGIN = l_loginid,
14720: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14804: UPDATE MTL_TRANSACTIONS_INTERFACE

14800: l_error_code := FND_MESSAGE.get;
14801: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
14802: l_error_exp := FND_MESSAGE.get;
14803: x_msg_data := l_error_exp;
14804: UPDATE MTL_TRANSACTIONS_INTERFACE
14805: SET LAST_UPDATE_DATE = SYSDATE,
14806: LAST_UPDATED_BY = l_userid,
14807: LAST_UPDATE_LOGIN = l_loginid,
14808: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14818: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14814: AND PROCESS_FLAG = 1;
14815: --check for batch error
14816: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14817:
14818: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14819: SET LAST_UPDATE_DATE = SYSDATE,
14820: LAST_UPDATED_BY = l_userid,
14821: LAST_UPDATE_LOGIN = l_loginid,
14822: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14866: UPDATE MTL_TRANSACTIONS_INTERFACE

14862: FND_MESSAGE.set_token('token1','XACT_QTY1');
14863: l_error_code := FND_MESSAGE.get;
14864: l_error_exp := l_msg_data;
14865: x_msg_data := l_msg_data;
14866: UPDATE MTL_TRANSACTIONS_INTERFACE
14867: SET LAST_UPDATE_DATE = SYSDATE,
14868: LAST_UPDATED_BY = l_userid,
14869: LAST_UPDATE_LOGIN = l_loginid,
14870: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14880: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14876: AND PROCESS_FLAG = 1;
14877: --check for batch error
14878: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14879:
14880: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14881: SET LAST_UPDATE_DATE = SYSDATE,
14882: LAST_UPDATED_BY = l_userid,
14883: LAST_UPDATE_LOGIN = l_loginid,
14884: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14906: UPDATE MTL_TRANSACTIONS_INTERFACE

14902: FND_MESSAGE.set_token('token1','XACT_QTY1');
14903: l_error_code := FND_MESSAGE.get;
14904: l_error_exp := l_msg_data;
14905: x_msg_data := l_msg_data;
14906: UPDATE MTL_TRANSACTIONS_INTERFACE
14907: SET LAST_UPDATE_DATE = SYSDATE,
14908: LAST_UPDATED_BY = l_userid,
14909: LAST_UPDATE_LOGIN = l_loginid,
14910: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14920: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14916: AND PROCESS_FLAG = 1;
14917: --check for batch error
14918: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14919:
14920: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14921: SET LAST_UPDATE_DATE = SYSDATE,
14922: LAST_UPDATED_BY = l_userid,
14923: LAST_UPDATE_LOGIN = l_loginid,
14924: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14960: UPDATE MTL_TRANSACTIONS_INTERFACE

14956: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
14957: l_error_exp := FND_MESSAGE.get;
14958: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
14959: x_msg_data := l_error_exp;
14960: UPDATE MTL_TRANSACTIONS_INTERFACE
14961: SET LAST_UPDATE_DATE = SYSDATE,
14962: LAST_UPDATED_BY = l_userid,
14963: LAST_UPDATE_LOGIN = l_loginid,
14964: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14974: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14970: AND PROCESS_FLAG = 1;
14971: --check for batch error
14972: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14973:
14974: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14975: SET LAST_UPDATE_DATE = SYSDATE,
14976: LAST_UPDATED_BY = l_userid,
14977: LAST_UPDATE_LOGIN = l_loginid,
14978: PROGRAM_UPDATE_DATE = SYSDATE,

Line 15004: UPDATE MTL_TRANSACTIONS_INTERFACE

15000: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
15001: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
15002: l_error_exp := FND_MESSAGE.get;
15003: x_msg_data := l_error_exp;
15004: UPDATE MTL_TRANSACTIONS_INTERFACE
15005: SET LAST_UPDATE_DATE = SYSDATE,
15006: LAST_UPDATED_BY = l_userid,
15007: LAST_UPDATE_LOGIN = l_loginid,
15008: PROGRAM_UPDATE_DATE = SYSDATE,

Line 15018: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

15014: AND PROCESS_FLAG = 1;
15015: --check for batch error
15016: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
15017:
15018: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
15019: SET LAST_UPDATE_DATE = SYSDATE,
15020: LAST_UPDATED_BY = l_userid,
15021: LAST_UPDATE_LOGIN = l_loginid,
15022: PROGRAM_UPDATE_DATE = SYSDATE,

Line 15077: UPDATE MTL_TRANSACTIONS_INTERFACE

15073: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
15074: l_error_code:= fnd_message.get;
15075: l_error_exp :=l_msg_data;
15076: x_msg_data := l_msg_data;
15077: UPDATE MTL_TRANSACTIONS_INTERFACE
15078: SET LAST_UPDATE_DATE = SYSDATE,
15079: LAST_UPDATED_BY = l_userid,
15080: LAST_UPDATE_LOGIN = l_loginid,
15081: PROGRAM_UPDATE_DATE = SYSDATE,

Line 15091: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

15087: AND PROCESS_FLAG = 1;
15088: --check for batch error
15089: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
15090:
15091: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
15092: SET LAST_UPDATE_DATE = SYSDATE,
15093: LAST_UPDATED_BY = l_userid,
15094: LAST_UPDATE_LOGIN = l_loginid,
15095: PROGRAM_UPDATE_DATE = SYSDATE,

Line 15146: UPDATE MTL_TRANSACTIONS_INTERFACE

15142: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
15143: l_error_code:= fnd_message.get;
15144: l_error_exp :=l_msg_data;
15145: x_msg_data := l_msg_data;
15146: UPDATE MTL_TRANSACTIONS_INTERFACE
15147: SET LAST_UPDATE_DATE = SYSDATE,
15148: LAST_UPDATED_BY = l_userid,
15149: LAST_UPDATE_LOGIN = l_loginid,
15150: PROGRAM_UPDATE_DATE = SYSDATE,

Line 15160: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

15156: AND PROCESS_FLAG = 1;
15157: --check for batch error
15158: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
15159:
15160: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
15161: SET LAST_UPDATE_DATE = SYSDATE,
15162: LAST_UPDATED_BY = l_userid,
15163: LAST_UPDATE_LOGIN = l_loginid,
15164: PROGRAM_UPDATE_DATE = SYSDATE,

Line 15217: FROM mtl_transactions_interface

15213: END IF;
15214:
15215: SELECT COUNT(*)
15216: INTO l_count_success
15217: FROM mtl_transactions_interface
15218: WHERE transaction_header_id = l_header_id
15219: AND process_flag = 1;
15220:
15221: IF (l_count_success = 0) THEN

Line 15237: UPDATE MTL_TRANSACTIONS_INTERFACE

15233: END IF;
15234: FND_MESSAGE.set_name('INV','INV_INT_TMPXFRCODE');
15235: l_error_code := FND_MESSAGE.get;
15236: x_msg_data := l_error_exp;
15237: UPDATE MTL_TRANSACTIONS_INTERFACE
15238: SET LAST_UPDATE_DATE = SYSDATE,
15239: LAST_UPDATED_BY = l_userid,
15240: LAST_UPDATE_LOGIN = l_loginid,
15241: PROGRAM_UPDATE_DATE = SYSDATE,

Line 15257: FROM MTL_TRANSACTIONS_INTERFACE

15253: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
15254: WHERE TRANSACTION_INTERFACE_ID
15255: IN(
15256: SELECT TRANSACTION_INTERFACE_ID
15257: FROM MTL_TRANSACTIONS_INTERFACE
15258: WHERE TRANSACTION_HEADER_ID =l_header_id
15259: AND PROCESS_FLAG <> 3
15260: union all
15261: SELECT SERIAL_TRANSACTION_TEMP_ID

Line 15266: FROM MTL_TRANSACTIONS_INTERFACE

15262: FROM MTL_TRANSACTION_LOTS_INTERFACE
15263: WHERE TRANSACTION_INTERFACE_ID
15264: IN (
15265: SELECT TRANSACTION_INTERFACE_ID
15266: FROM MTL_TRANSACTIONS_INTERFACE
15267: WHERE TRANSACTION_HEADER_ID = l_header_id
15268: AND PROCESS_FLAG <> 3 )) ;
15269: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
15270: WHERE TRANSACTION_INTERFACE_ID IN

Line 15272: FROM MTL_TRANSACTIONS_INTERFACE

15268: AND PROCESS_FLAG <> 3 )) ;
15269: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
15270: WHERE TRANSACTION_INTERFACE_ID IN
15271: (SELECT TRANSACTION_INTERFACE_ID
15272: FROM MTL_TRANSACTIONS_INTERFACE
15273: WHERE TRANSACTION_HEADER_ID =l_header_id
15274: AND PROCESS_FLAG <> 3);
15275: DELETE FROM MTL_TRANSACTIONS_INTERFACE
15276: WHERE TRANSACTION_HEADER_ID = l_header_id

Line 15275: DELETE FROM MTL_TRANSACTIONS_INTERFACE

15271: (SELECT TRANSACTION_INTERFACE_ID
15272: FROM MTL_TRANSACTIONS_INTERFACE
15273: WHERE TRANSACTION_HEADER_ID =l_header_id
15274: AND PROCESS_FLAG <> 3);
15275: DELETE FROM MTL_TRANSACTIONS_INTERFACE
15276: WHERE TRANSACTION_HEADER_ID = l_header_id
15277: AND PROCESS_FLAG <> 3;
15278: IF (l_debug = 1) THEN
15279: inv_log_util.trace('*** Del recs mti valid trx', 'INV_TXN_MANAGER_GRP',9);

Line 15295: UPDATE MTL_TRANSACTIONS_INTERFACE

15291:
15292: FND_MESSAGE.set_name('INV','INV_INT_SQLCODE');
15293: l_error_code := FND_MESSAGE.get;
15294:
15295: UPDATE MTL_TRANSACTIONS_INTERFACE
15296: SET LAST_UPDATE_DATE = SYSDATE,
15297: LAST_UPDATED_BY = l_userid,
15298: LAST_UPDATE_LOGIN = l_loginid,
15299: PROGRAM_UPDATE_DATE = SYSDATE,

Line 15376: FROM mtl_transactions_interface

15372:
15373: /* Bug# 13539797 cursor to get the txn date from MTI */
15374: CURSOR c_get_txn_date IS
15375: SELECT transaction_date
15376: FROM mtl_transactions_interface
15377: WHERE transaction_interface_id = p_intid;
15378:
15379: l_transaction_date DATE; -- Bug# 13539797
15380: