DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2524: mtl_material_transactions_s.nextval seq_num,

2520: CURSOR c_serial_numbers (c_delivery_detail_id NUMBER) IS
2521: SELECT fm_serial_number,
2522: to_serial_number,
2523: rownum, --haperf
2524: mtl_material_transactions_s.nextval seq_num,
2525: attribute_category,
2526: attribute1,
2527: attribute2,
2528: attribute3,

Line 2644: mtl_material_transactions_s.nextval trx_interface_id,

2640: ship_to_location_id,
2641: requisition_line_id,
2642: requisition_distribution_id,
2643: trx_uom,
2644: mtl_material_transactions_s.nextval trx_interface_id,
2645: shipment_number,
2646: expected_arrival_date,
2647: encumbrance_account,
2648: encumbrance_amount,

Line 2776: SELECT mtl_material_transactions_s.nextval

2772:
2773:
2774:
2775: CURSOR get_interface_id IS
2776: SELECT mtl_material_transactions_s.nextval
2777: FROM sys.dual;
2778:
2779:
2780: -- FP bug 4166635: cursor to look up trip's freight carrier

Line 4220: SELECT mtl_material_transactions_s.nextval

4216:
4217: END IF;
4218: -- bug 5736840
4219:
4220: SELECT mtl_material_transactions_s.nextval
4221: INTO l_transaction_header_id
4222: FROM sys.dual;
4223: --
4224: IF l_debug_on THEN