DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3013: mtl_material_transactions_s.nextval seq_num,

3009: CURSOR c_serial_numbers (c_delivery_detail_id NUMBER) IS
3010: SELECT fm_serial_number,
3011: to_serial_number,
3012: rownum, --haperf
3013: mtl_material_transactions_s.nextval seq_num,
3014: attribute_category,
3015: attribute1,
3016: attribute2,
3017: attribute3,

Line 3253: mtl_material_transactions_s.nextval trx_interface_id,

3249: ship_to_location_id,
3250: requisition_line_id,
3251: requisition_distribution_id,
3252: trx_uom,
3253: mtl_material_transactions_s.nextval trx_interface_id,
3254: shipment_number,
3255: expected_arrival_date,
3256: encumbrance_account,
3257: encumbrance_amount,

Line 3386: SELECT mtl_material_transactions_s.nextval

3382:
3383:
3384:
3385: CURSOR get_interface_id IS
3386: SELECT mtl_material_transactions_s.nextval
3387: FROM sys.dual;
3388:
3389:
3390: -- FP bug 4166635: cursor to look up trip's freight carrier

Line 5198: SELECT mtl_material_transactions_s.nextval

5194:
5195: END IF;
5196: -- bug 5736840
5197:
5198: SELECT mtl_material_transactions_s.nextval
5199: INTO l_transaction_header_id
5200: FROM sys.dual;
5201: --
5202: IF l_debug_on THEN