DBA Data[Home] [Help]

APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on FND_GLOBAL

Line 576: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id

572: VALUES(
573: x_new_txn_temp_id
574: , curr_lot.lot_number,least(l_rem_txn_qty, l_lot_txn_qty), least(l_rem_pri_qty, l_lot_pri_qty)
575: , mtl_material_transactions_s.NEXTVAL, l_txn_header_id
576: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id
577: , DECODE(least(NVL(l_rem_sec_txn_qty,0), NVL(l_lot_sec_qty,0))
578: ,0,NULL
579: ,least(NVL(l_rem_sec_txn_qty,0), NVL(l_lot_sec_qty,0)))--INVCONV kkillams
580: )

Line 602: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id

598: , last_update_date, last_updated_by, creation_date, created_by
599: )
600: SELECT l_serial_txn_temp_id
601: , serial_number, serial_number, 1
602: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id
603: FROM mtl_allocations_gtmp
604: WHERE transaction_temp_id = p_transaction_temp_id
605: AND lot_number = curr_lot.lot_number
606: AND ROWNUM <= l_lot_pri_qty;

Line 641: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id

637: , last_update_date, last_updated_by, creation_date, created_by
638: )
639: SELECT x_new_txn_temp_id
640: , serial_number, serial_number, 1
641: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id
642: FROM mtl_allocations_gtmp
643: WHERE transaction_temp_id = p_transaction_temp_id
644: AND ROWNUM <= l_rem_pri_qty;
645: l_insert_count := SQL%ROWCOUNT;