DBA Data[Home] [Help]

APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on FND_GLOBAL

Line 493: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id

489: VALUES(
490: x_new_txn_temp_id
491: , curr_lot.lot_number,least(l_rem_txn_qty, l_lot_txn_qty), least(l_rem_pri_qty, l_lot_pri_qty)
492: , mtl_material_transactions_s.NEXTVAL, l_txn_header_id
493: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id
494: , DECODE(least(NVL(l_rem_sec_txn_qty,0), NVL(l_lot_sec_qty,0))
495: ,0,NULL
496: ,least(NVL(l_rem_sec_txn_qty,0), NVL(l_lot_sec_qty,0)))--INVCONV kkillams
497: )

Line 519: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id

515: , last_update_date, last_updated_by, creation_date, created_by
516: )
517: SELECT l_serial_txn_temp_id
518: , serial_number, serial_number, 1
519: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id
520: FROM mtl_allocations_gtmp
521: WHERE transaction_temp_id = p_transaction_temp_id
522: AND lot_number = curr_lot.lot_number
523: AND ROWNUM <= l_lot_pri_qty;

Line 558: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id

554: , last_update_date, last_updated_by, creation_date, created_by
555: )
556: SELECT x_new_txn_temp_id
557: , serial_number, serial_number, 1
558: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id
559: FROM mtl_allocations_gtmp
560: WHERE transaction_temp_id = p_transaction_temp_id
561: AND ROWNUM <= l_rem_pri_qty;
562: l_insert_count := SQL%ROWCOUNT;